=IF()

  • Thread starter Thread starter Angie
  • Start date Start date
A

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!!!
 
=IF(AND(A2="Asplundh",F2>)),....


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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")
 
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)
 
Back
Top