IF formula-simple question; simple operator

  • Thread starter Thread starter Rich D
  • Start date Start date
R

Rich D

If the entry in A1 is "Job", and if any of the cells B1, C1, D1 are blank, I
want to return (in cell E1) the message "MISSING INFO". I know it's simple
but I'm missing something myself.

Thanks,
 
I am not sure you would call this simple, but try this formula in cell E1

=IF(AND(A1="JOB",OR(ISBLANK(B1),OR(ISBLANK(C1),ISBLANK(D1)))),"MISSING
INFO","ALL DATA THERE")
 
In E1 enter:
=IF(OR(ISBLANK(B1),ISBLANK(C1),ISBLANK(D1)),"MISSING INFO","")
 
Try this in E1

=IF(A1="job",IF(COUNTA(B1:D1)<3,"Missing date",""),"This appears if Job
isn't in A1")


You don't specify what to do if A1 doesn't contain Job so this formula
displays
This appears if Job isn't in A1
You could simply leave emprt quotes and display nothing if you prefer.

Mike
 
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

How To Have A Cell Be Blank If... 2
Formula for If "" AND "" are true... 3
Nested IF Help 3
Looking at multiple cells 3
Excel Add ^ to a row of cells containing letters 3
Excel 2007 storing the high and low 3
Simple Average ? 3
Need data result in last cell of array that contains blank cells 2

Back
Top