=IF()

[Angie]

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(F2>0)

then

enter text "118332"

Please Help!!!

 

[Trevor Williams]

=IF(AND(A2="Asplundh",F2>0),"118332","something else")

 

[Bob Phillips]

=IF(AND(A2="Asplundh",F2>)),....


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Angie]

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",F2>0),"118332","something else")
(AND(A2="Asplundh",E2>0),"XXXX","something else")
(AND(A2="Townsend Tree",E2>0),"118397","something else")
(AND(A2="Townsend Tree",F2>0),"XXX","something else")

 

[Bob Phillips]

NO NEED TO SHOUT!

=IF(A2="Asplundh",IF(F2>0,"118332",IF(E2>0,"XXXX","something
else")),IF(A2="Townsend Tree",IF(F2>0,"XXX",IF(E2>0,"118397","something
else")),"something else"))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Angie]

Thank you! Sorry, forgetting Caps lock is on is a bad habbit.