Thread: =IF()
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default =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!!!