ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   blank cells (https://www.excelbanter.com/excel-worksheet-functions/43594-blank-cells.html)

Karen

blank cells
 
I have the following: =IF(H7<=$J$3,"12/31/2006","Not Available"), which works
for the True/False. However, how do I throw in another variable: if H7 is a
blank cell, then "immediately" is the result? thx, Karen



Bob Phillips

see other post

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Karen" wrote in message
...
I have the following: =IF(H7<=$J$3,"12/31/2006","Not Available"), which

works
for the True/False. However, how do I throw in another variable: if H7 is

a
blank cell, then "immediately" is the result? thx, Karen






All times are GMT +1. The time now is 07:13 PM.

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