Need help creating a formula

  • Thread starter Thread starter storeman4966
  • Start date Start date
S

storeman4966

I would like to create a formula that will check to see if there is
value in one of two cells, multiply the found value by a value i
another cell and return a total.

Specifically:
Cell B1 Cell B2 CellB3

Either B1 or B2 will contain a value, not both.

If B1 has a value, it will be multiplied by the value in B37 and th
result displayed in B3.

If B2 has a value, it will be multiplied by the value in B38 and th
result displayed in B3.

Th
 
One way:

B3: =SUMPRODUCT(B1:B2,B37:B38)

another:

B3: =IF(COUNT(B1),B1*B37,B2*B38)
 
This simple formula should work for all situations except the dreaded space
bar in either b1 or b2
=B1*B37+B2*B38
 
Back
Top