| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Update Links Message is False but Always Appears | Excel Discussion (Misc queries) | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| Entering only 2 values out of 3 - throws up message as false | Excel Worksheet Functions | |||
| Hiding FALSE message | Excel Discussion (Misc queries) | |||
| $C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # | Excel Worksheet Functions | |||
Linear Mode
