Need help creating a formula

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
 
J

JE McGimpsey

One way:

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

another:

B3: =IF(COUNT(B1),B1*B37,B2*B38)
 
D

Don Guillett

This simple formula should work for all situations except the dreaded space
bar in either b1 or b2
=B1*B37+B2*B38
 
Top