| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
keep cell blank if IF statement is False
Thanks, I did not realize that =sum(a1,b1) when a1 = "" would not return
#VALUE. Peo Sjoblom wrote: Post the formula that returns the value error, a value error occurs when you calculate with text like "" so you can replace it with 0 instead if you add it or you can use functions that ignores text like SUM or SUMIF |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell is blank, then cell is red | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| blank cell turns to 0 | New Users to Excel | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
