Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF ... and... HELP ... :)
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|