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")))
 
Top