View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FangYR
 
Posts: n/a
Default =IF(AND(F269,F2<90),25,IF(F2100,60,""))

=IF(AND(F269,F2<90),25,IF(F2100,60,""))
The above formula works well until I modify it as below:

=IF(AND(F269,F2<75),25,IF(F275,F2.90),27,IF(F21 00,60,""))
It displays an error message indicating the problem is with 27, and I
dont see why.
Please help.
Thanks
--
Regards
FangYR
Malaysia