=IF(AND(F2>69,F2<90),25,IF(F2>100,60,""))

F

FangYR

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

=IF(AND(F2>69,F2<75),25,IF(F2>75,F2.90),27,IF(F2>100,60,""))
It displays an error message indicating the problem is with “27â€, and I
don’t see why.
Please help.
Thanks
 
R

Ron Coderre

See if this variation works for you:
=IF(AND(F2>69,F2<75),25,IF(AND(F2>75,F2<90),27,IF(F2>100,60,"")))

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

Does that help?

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

XL2002, WinXP-Pro
 
B

bpeltzer

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?
 
F

FangYR

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.
 
G

Guest

Hi

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

Andy.
 
F

FangYR

Hi Ron,
Thanks for that, but it only works with input "70", "75" and anything above
"100"
When I input "80" it give a blank.
Regards
FangYR
Malaysia
 
F

FangYR

Oh sorry Andy,
it should be:
Now I want something that can work out:
if F2 is more than 60 and less than75, then 25, if F2 is more than 75 and
less than 90, then 27, but if more than 100, then 60.
(if anything between 90-100, still 27, but not require yet)
 
F

FangYR

Yes, Thanks for that variation.
With some modifications, it works.
=IF(AND(F29>69,F29<74),25,IF(AND(F29>74,F29<90),27,IF(F29>100,60,"")))
Thanks again Ron Conderre.
 
S

Sloth

if F2 is more than 60 and less than75, then 25, if F2 is more than 75 and
less than 90, then 27, but if more than 100, then 60.
=IF(F2<60,"",IF(F2<75,25,IF(F2<90,27,60)))

(if anything between 90-100, still 27, but not require yet)
Click to expand...

=IF(F2<60,"",IF(F2<75,25,IF(F2<90,27,IF(F2<100,27,60))))
or
=IF(F2<60,"",IF(F2<75,25,IF(F2<100,27,60)))
because you have the same output for 75-90 and 90-100.

AND is not a good function to use with what you are doing, but if you have
to use it your original function just had some syntax errors.

FangYR said:
Oh sorry Andy,
it should be:
Now I want something that can work out:
if F2 is more than 60 and less than75, then 25, if F2 is more than 75 and
less than 90, then 27, but if more than 100, then 60.
(if anything between 90-100, still 27, but not require yet)
Click to expand...
 
R

Ron Coderre

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

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

XL2002, WinXP-Pro
 
Top