ExcelBanter - FALSE message

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - FALSE message (https://www.excelbanter.com/excel-discussion-misc-queries/246098-false-message.html)

James

FALSE message

=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

FALSE message

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

If this post helps click Yes
---------------
Jacob Skaria

"james" wrote:

=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.

T. Valko

FALSE message

=IF(J22,B49*1.5+J22)

Try this...

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

--
Biff
Microsoft Excel MVP

"james" wrote in message
...
=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.

All times are GMT +1. The time now is 06:40 AM.