IF formula
 

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.

IF formula
 

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

--

Regards
Roger Govier

"Tufail" wrote in message
...
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.

IF formula
 

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

"Tufail" wrote in message
...
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.

IF formula
 

Much neater, David!

--

Regards
Roger Govier

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(B1="",IF(C1="","Waiting","Back"),IF(C1="","Go" ,"Finished"))
--
David Biddulph

"Tufail" wrote in message
...
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.

IF formula
 

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

"Tufail" wrote in message
...
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.