Thanks for the feedback.....I'm glad you got that to work.

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

XL2002, WinXP-Pro


"FangYR" wrote:

Yes, Thanks for that variation.
With some modifications, it works.
=IF(AND(F2969,F29<74),25,IF(AND(F2974,F29<90),27 ,IF(F29100,60,"")))
Thanks again Ron Conderre.
--
Regards
FangYR
Malaysia


"Ron Coderre" wrote:

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