Thread: IF ... and... HELP ... :)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default IF ... and... HELP ... :)
=IF(AND(AI22=1,P2220%),"D","-")

--
Regards,
Tom Ogilvy


"Darin Kramer" wrote in message
...


Whats wrong with my formulae..

=IF(AND(AI22=1,(P2220%),"D","-"))

I want it to say if AI22 = 1 and if p22 is greater than 20% then put a
D, if not put a -.

Where am i going wrogn... Thanks...

D

*** Sent via Developersdex http://www.developersdex.com ***


Reply With QuoteReply With Quote