| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
returning blank cell when conditions not met
Thanks guys I'll give it a try.
"kfarley" wrote: Entered into G7 the following =IF(F7<3,3-F7,0) F7 is the SUM of C7,D7,E7 If there are no entries in C7,D7 and E7 I want G7 to be blank. meaning until there are numbers entered I don't want to see 0 in G7 Any ideas. Since i can't seem to find a way to put in an else statement with excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a Value if 3 Conditions are True | Excel Worksheet Functions | |||
| Returning a blank cell rather then #N/A (Lookup) | Excel Discussion (Misc queries) | |||
| returning blank cell | Excel Worksheet Functions | |||
| returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
| Formulas returning a blank if no data entered in one cell | New Users to Excel | |||
Threaded Mode
