=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

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

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
dont see why.
Please help.
Thanks
--
Regards
FangYR
Malaysia

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
dont see why.
Please help.
Thanks
--
Regards
FangYR
Malaysia

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

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


"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

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)
--
Regards
FangYR
Malaysia


"Andy" wrote:

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

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

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)

=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" wrote:

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)
--
Regards
FangYR
Malaysia


"Andy" wrote:

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

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