IF formula

T

Tufail

Hello
I am looking some formula for following in A1

If B1 & C1 are blanks then in > A1 "Waiting"
If B1 has any value and C1 is blank then in > A1 "Go"
If B1 is blank and C1 has value then in > A1 "Back"
If B1 & C1 have any value then in > A1 "Finished"

Thanks in advance.
 
R

Roger Govier

Hi
Try
=IF(AND(B1="",C1=""),"Waiting",IF(AND(B1<>"",C1<>""),
"Finished",IF(AND(B1<>"",C1=""),"Go","Back")))
 
S

Stephen

Does this do what you want?
=IF(AND(B1="",C1=""),"Waiting",IF(C1="","Go",IF(B1="","Back","Finished")))
 

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

Formula 4
Satisfying several criteria 4
IF 4
If Functions Time 13
copy and paste the cell with formula ="1" 3
if then formula 2
Multiple if condition formula required 4
need formula returning a blank cell 4

Top