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

See if this variation works for you:
=IF(AND(F269,F2<75),25,IF(AND(F275,F2<90),27,IF( F2100,60,"")))

It may need some tweaking, but it's syntactically correct.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"FangYR" wrote:

=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