| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keep cell blank when false in IF statement
How do I keep the cell blank when doing an IF statement. I want the cell to
remain blank if the statement is false but it keeps putting False in the cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep cell blank when false in IF statement
ruthslaughter wrote:
How do I keep the cell blank when doing an IF statement. I want the cell to remain blank if the statement is false but it keeps putting False in the cell. If A1 is blank leave B3 blank, otherwise put A1 in B3 =IF(A1=""," ",A1) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200511/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
keep cell blank when false in IF statement
To have a "blank" result for the FALSE return try this: =IF(A10,A1,"") Use 2 double quotes for the FALSE option. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=487308 |
| Reply |
| 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 | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
