| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
returning blank cells in an IF function
I have a function which reads =IF(TODAY()=A6,C6-B6,"Blank")
I am trying to have it return an empty cell if the statement is false and I can't find to right keyword. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
returning blank cells in an IF function
=IF(TODAY()=A6,C6-B6,"")
Vaya con Dios, Chuck, CABGx3 "Squeky" wrote in message ... I have a function which reads =IF(TODAY()=A6,C6-B6,"Blank") I am trying to have it return an empty cell if the statement is false and I can't find to right keyword. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace cells with blank | Excel Worksheet Functions | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| write a function to determine if cells have names | Excel Worksheet Functions | |||
| Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Linear Mode
