Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep cell blank if condition is false in IF function
How do I keep the cell blank if the condition is false. Even if I don't put
anything in the false condition it keeps putting False in the cell, I want to leave it blank. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep cell blank if condition is false in IF function
=if(condition,value_if_true,"")
"ruthslaughter" wrote: How do I keep the cell blank if the condition is false. Even if I don't put anything in the false condition it keeps putting False in the cell, I want to leave it blank. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep cell blank if condition is false in IF function
Note that this makes the cell look blank, but Excel still treats it as if it
contains text. This has implications if the cell is used for subsequent calculations or as a chart's source data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "bpeltzer" wrote in message ... =if(condition,value_if_true,"") "ruthslaughter" wrote: How do I keep the cell blank if the condition is false. Even if I don't put anything in the false condition it keeps putting False in the cell, I want to leave it blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |