View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Shatin[_2_] Shatin[_2_] is offline
external usenet poster
 
Posts: 56
Default IF ... and... HELP ... :)

There's a ) missing after 20%. Formula should be:

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

"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 ***