FALSE message

[james]

=IF(J22,B49*1.5+J22)

how do i stop the false message in this formula when J22 is empty?
B49 is labour price, 1.5 is amount of hours, J22 is unit price.

 

[Jacob Skaria]

=IF(J22,B49*1.5+J22,"")



If this post helps click Yes

 

[T. Valko]

=IF(J22,B49*1.5+J22)

Try this...

=IF(COUNT(J22),B49*1.5+J22,"")