Checking for a blank Cell

[stevie_ray]

Hi Julie managed to fix the #REF problem. However, it is still doing th
same (i.e. displaying EXPIRED instead of N/A hwn there is no data in th
corresponding cells?

Hope you can help?

Thanks a lot!

Mar

 

[Dave Peterson]

=if(iserror(yourformula),"EXPIRED",yourformula)

should work ok.