Checking for a blank Cell

[stevie_ray]

Hi there,

I am currently devising a formula within the N column of m
spreadsheet. I am using a lookup table to check whether or not th
apartments I have are "In Progress" or "Expired". I have managed to d
this successfully. However, I wish to create a third option of N/A whe
a flat is not occupied (i.e. there isn't a date of expiration in the
column). I believe that I shall need a nested IF statement to do a
additional check to the current formula I have for the N colum
=IF('LOOK-UP'!$B$1>+'18 OCT - 14 NOV 2004'!M2,"EXPIRED","I
PROGRESS").

Hope someone can help!

Regards,

Mar

+-------------------------------------------------------------------
|Filename: 4 Weekly Rentals - Falkirk.zip
|Download: http://www.excelforum.com/attachment.php?postid=2744
+-------------------------------------------------------------------

 

[JulieD]

Hi Stevie

try

=IF('LOOK-UP'!$B$1>='18 OCT - 14 NOV 2004'!M2,"EXPIRED",IF('18 OCT - 14 NOV
2004'!M2="","N/A","IN PROGRESS")).

Cheers
JulieD

 

[JulieD]

second option try

=IF('18 OCT - 14 NOV 2004'!M2="","N/A",IF('LOOK-UP'!$B$1>='18 OCT - 14 NOV
2004'!M2,"EXPIRED","IN PROGRESS")).

Cheers
JulieD