Hi

Try this:
=IF(AND(F260,F2<90),27,IF(F2100,60))
What if F2 is between 90 and 100, or less than 60?

Andy.

"FangYR" wrote in message
...
If F2 is more than 69 and less than 90, then 25 points(or whatever), but
if
F2is more than 100, then 60pts.
Now I want something that can work out:
if F2 is more than 60 and less than75, then 27, if F2 is more than 75 and
less than 90, then 27, but if more than 100, then 60.
--
Regards
FangYR
Malaysia


"bpeltzer" wrote:

There are a couple of problems. First, what is F2.90? Second, the
right-paren after the 90 closes off the 'then' clause of the first IF so
that
27 looks like a fourth argument of the IF function, generating an error.
Can you explain your intention in words?

"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
don't see why.
Please help.
Thanks
--
Regards
FangYR
Malaysia