| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display zero is no data is found
I have an IF formula that displays a zero if the number falls between a set
of numbers. =IF(B30450,B30-450,IF(B30<426,B30-426,"0")) But if no data is found in the reference cell then I want the cell the formula is in to display 0, how do you do that? Example would be that B30 is blank, I get a -426. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell Dropdown List. Display alternate text than found in list. | Excel Discussion (Misc queries) | |||
| Compare text in 2 separate spreadsheets, when match found display | Excel Worksheet Functions | |||
| how do I display filtered records found | Excel Discussion (Misc queries) | |||
| Data Source Name Not Found | Excel Worksheet Functions | |||
| how to display the count of lines found by autofilter? | Excel Discussion (Misc queries) | |||
Threaded Mode
