ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   returning blank cells in an IF function (https://www.excelbanter.com/excel-worksheet-functions/67501-returning-blank-cells-if-function.html)

Squeky

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.

CLR

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.





All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com