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!!!