Checking for a blank Cell

  • Thread starter Thread starter stevie_ray
  • Start date Start date
S

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
 
=if(iserror(yourformula),"EXPIRED",yourformula)

should work ok.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking for a blank Cell 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
I have a challenge for you 5
how to remove #REF and #N/A 3
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
How To Have A Cell Be Blank If... 2
#N/A Conditional Formatting affects all cells? 9
Emailing formula results 1

Back
Top