| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
