| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need to supress display of FALSE in a cell
I have entered a formula that seems to work ok, but is displaying false if an
invalid code is entered into one of the input cells. Is there any way to suppress the display of FALSE and just display spaces? The formula in question is as follows: =IF(I17="LH",(SUM(I28:M29)*30),IF(I17="OH1",(SUM(I 28:M29)*90),IF(I17="OH2",(SUM(I28:M29)*90),IF(I17= "EH1",(SUM(I28:M29)*120),IF(I17="EH2",(SUM(I28:M29 )*120)))))) Thanks for the help!! Ken K. - 2191 -- akkrug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display TRUE / FALSE Instead Of 1 / 0 | Excel Discussion (Misc queries) | |||
| Excel 2002 - Supress digits in a cell linked to a different workbo | Excel Discussion (Misc queries) | |||
| match data in 2 sheets then display true/false from vlkup | Excel Worksheet Functions | |||
| Stopping display of "FALSE" | Excel Discussion (Misc queries) | |||
| How can I display my "false" value as an actual value? | Excel Worksheet Functions | |||
Threaded Mode
