Excel Problem

[Danny]

Have at it guys.
I’m putting formula into A2. I want it to return a value for this formula,
but I think the syntax is wrong. Help greatly appreciated.
=IF(A1<=13,â€Aâ€,IF(A1>13<18,â€RESULTâ€,IF(A1>=18,â€Bâ€)))
Danny

 

[David Biddulph]

See your earlier two threads. Don't start a new thread when your question
has already been answered.

 

[John Moore]

Try this ...=IF(A1<=13,"A",IF(A1<18>13,"RESULT",IF(A1>=18,"B","")))

 

[David Biddulph]

I'm intrigued by your second test, John. You are comparing A1<18 with 13.
A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13, hence
A1<18>13 is always TRUE, so your test isn't doing anything useful. You may
wish to reconsider your advice to Danny?
[Or you may wish to let Danny take the advice which he was given in an
earlier thread where he asked the same question.]

 

[Danny]

Hi David,
Thanks for the correction. However, this is a different question than my
first post.
Danny

 

[Danny]

Thank you John. I'll give it a try.
Danny

Try this ...=IF(A1<=13,"A",IF(A1<18>13,"RESULT",IF(A1>=18,"B","")))

 

[Danny]

David,
Instead of criticizing John and me, it would have been good to put that
energy ito a solution to the problem. Have a nice day.
Danny

I'm intrigued by your second test, John. You are comparing A1<18 with 13.
A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13, hence
A1<18>13 is always TRUE, so your test isn't doing anything useful. You may
wish to reconsider your advice to Danny?
[Or you may wish to let Danny take the advice which he was given in an
earlier thread where he asked the same question.]
--
David Biddulph

Try this ...=IF(A1<=13,"A",IF(A1<18>13,"RESULT",IF(A1>=18,"B","")))

 

[David Biddulph]

Two different answers to your syntax error were given by Dave Peterson and
by Max in response to your original question in the thread "Excel ranges
within a cell".
--
David Biddulph

David,
Instead of criticizing John and me, it would have been good to put that
energy ito a solution to the problem. Have a nice day.
Danny

I'm intrigued by your second test, John. You are comparing A1<18 with
13.
A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13,
hence
A1<18>13 is always TRUE, so your test isn't doing anything useful. You
may
wish to reconsider your advice to Danny?
[Or you may wish to let Danny take the advice which he was given in an
earlier thread where he asked the same question.]
--
David Biddulph

Try this ...=IF(A1<=13,"A",IF(A1<18>13,"RESULT",IF(A1>=18,"B","")))

:

Have at it guys.
I'm putting formula into A2. I want it to return a value for this
formula,
but I think the syntax is wrong. Help greatly appreciated.
=IF(A1<=13,"A",IF(A1>13<18,"RESULT",IF(A1>=18,"B")))
Danny

 

[Danny]

thanks, Johan, I'll give it a try. Will let you know.
Danny

 

[Danny]

thank you David. I will look that up. Didn't realize I had entered the same
question under a different subject heading.
Danny

Two different answers to your syntax error were given by Dave Peterson and
by Max in response to your original question in the thread "Excel ranges
within a cell".
--
David Biddulph

David,
Instead of criticizing John and me, it would have been good to put that
energy ito a solution to the problem. Have a nice day.
Danny

I'm intrigued by your second test, John. You are comparing A1<18 with
13.
A1<18 is a Boolean. TRUE is less than 13, and FALSE is less than 13,
hence
A1<18>13 is always TRUE, so your test isn't doing anything useful. You
may
wish to reconsider your advice to Danny?
[Or you may wish to let Danny take the advice which he was given in an
earlier thread where he asked the same question.]
--
David Biddulph

Try this ...=IF(A1<=13,"A",IF(A1<18>13,"RESULT",IF(A1>=18,"B","")))

:

Have at it guys.
I'm putting formula into A2. I want it to return a value for this
formula,
but I think the syntax is wrong. Help greatly appreciated.
=IF(A1<=13,"A",IF(A1>13<18,"RESULT",IF(A1>=18,"B")))
Danny

 

[Danny]

Hi John,
That formula worked well for the parameters that I set out. Thank you very
much. As you know solving one problem can sometimes create others. What I
would also like the formula to be able to do is if there is no value entered
into cell A1, then nothing shows in cell A2. As the formula stands now, when
no value is entered in A1, "A" is printed in A2.
Danny