Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF()
I am trying to reference 2 cells in the logical test, but I cannot figure out
how to format the formula: =IF(A2="Asplundh") and =IF(F20) then enter text "118332" Please Help!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF()
=IF(AND(A2="Asplundh",F20),"118332","something else")
"Angie" wrote: I am trying to reference 2 cells in the logical test, but I cannot figure out how to format the formula: =IF(A2="Asplundh") and =IF(F20) then enter text "118332" Please Help!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF()
=IF(AND(A2="Asplundh",F2)),....
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Angie" wrote in message ... I am trying to reference 2 cells in the logical test, but I cannot figure out how to format the formula: =IF(A2="Asplundh") and =IF(F20) then enter text "118332" Please Help!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF()
I ACTUALLY NEED 4 CONDITIONS FOR THIS FORMULA, HOW WOULD I GO ABOUT THIS? i
NEED ALL OF THESE IN THE FORMULA FOR EACH CELL. (AND(A2="Asplundh",F20),"118332","something else") (AND(A2="Asplundh",E20),"XXXX","something else") (AND(A2="Townsend Tree",E20),"118397","something else") (AND(A2="Townsend Tree",F20),"XXX","something else") "Trevor Williams" wrote: =IF(AND(A2="Asplundh",F20),"118332","something else") "Angie" wrote: I am trying to reference 2 cells in the logical test, but I cannot figure out how to format the formula: =IF(A2="Asplundh") and =IF(F20) then enter text "118332" Please Help!!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF()
NO NEED TO SHOUT!
=IF(A2="Asplundh",IF(F20,"118332",IF(E20,"XXXX", "something else")),IF(A2="Townsend Tree",IF(F20,"XXX",IF(E20,"118397","something else")),"something else")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Angie" wrote in message ... I ACTUALLY NEED 4 CONDITIONS FOR THIS FORMULA, HOW WOULD I GO ABOUT THIS? i NEED ALL OF THESE IN THE FORMULA FOR EACH CELL. (AND(A2="Asplundh",F20),"118332","something else") (AND(A2="Asplundh",E20),"XXXX","something else") (AND(A2="Townsend Tree",E20),"118397","something else") (AND(A2="Townsend Tree",F20),"XXX","something else") "Trevor Williams" wrote: =IF(AND(A2="Asplundh",F20),"118332","something else") "Angie" wrote: I am trying to reference 2 cells in the logical test, but I cannot figure out how to format the formula: =IF(A2="Asplundh") and =IF(F20) then enter text "118332" Please Help!!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=IF()
Thank you! Sorry, forgetting Caps lock is on is a bad habbit.
"Bob Phillips" wrote: NO NEED TO SHOUT! =IF(A2="Asplundh",IF(F20,"118332",IF(E20,"XXXX", "something else")),IF(A2="Townsend Tree",IF(F20,"XXX",IF(E20,"118397","something else")),"something else")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Angie" wrote in message ... I ACTUALLY NEED 4 CONDITIONS FOR THIS FORMULA, HOW WOULD I GO ABOUT THIS? i NEED ALL OF THESE IN THE FORMULA FOR EACH CELL. (AND(A2="Asplundh",F20),"118332","something else") (AND(A2="Asplundh",E20),"XXXX","something else") (AND(A2="Townsend Tree",E20),"118397","something else") (AND(A2="Townsend Tree",F20),"XXX","something else") "Trevor Williams" wrote: =IF(AND(A2="Asplundh",F20),"118332","something else") "Angie" wrote: I am trying to reference 2 cells in the logical test, but I cannot figure out how to format the formula: =IF(A2="Asplundh") and =IF(F20) then enter text "118332" Please Help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|