IF formula

[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.

 

[Roger Govier]

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

 

[David Biddulph]

=IF(B1="",IF(C1="","Waiting","Back"),IF(C1="","Go","Finished"))

 

[Roger Govier]

Much neater, David!

--

Regards
Roger Govier

=IF(B1="",IF(C1="","Waiting","Back"),IF(C1="","Go","Finished"))

 

[Stephen]

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