Excel Problem
 

Have at it guys.
Im 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(A113<18,€�RESULT€�,IF(A1 =18,€�B€�)))
Danny

Excel Problem
 

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

"Danny" wrote in message
...
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(A113<18,"RESULT",IF(A1=18,"B") ))
Danny

Excel Problem
 

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

"Danny" wrote:

Have at it guys.
Im 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(A113<18,€�RESULT€�,IF(A1 =18,€�B€�)))
Danny

Excel Problem
 

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<1813 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

"John Moore" wrote in message
...
Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B","")))

"Danny" wrote:

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(A113<18,"RESULT",IF(A1=18,"B") ))
Danny

Excel Problem
 

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

"David Biddulph" wrote:

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

"Danny" wrote in message
...
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(A113<18,"RESULT",IF(A1=18,"B") ))
Danny

Excel Problem
 

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

"John Moore" wrote:

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

"Danny" wrote:

Have at it guys.
Im 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(A113<18,€�RESULT€�,IF(A1 =18,€�B€�)))
Danny

Excel Problem
 

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

"David Biddulph" wrote:

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<1813 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

"John Moore" wrote in message
...
Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B","")))

"Danny" wrote:

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(A113<18,"RESULT",IF(A1=18,"B") ))
Danny

Excel Problem
 

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

"Danny" wrote in message
...
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

"David Biddulph" wrote:

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<1813 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

"John Moore" wrote in message
...
Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B","")))

"Danny" wrote:

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(A113<18,"RESULT",IF(A1=18,"B") ))
Danny

Excel Problem
 

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

"John Moore" wrote:

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

"Danny" wrote:

Have at it guys.
Im 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(A113<18,€�RESULT€�,IF(A1 =18,€�B€�)))
Danny

Excel Problem
 

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

"David Biddulph" wrote:

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

"Danny" wrote in message
...
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

"David Biddulph" wrote:

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<1813 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

"John Moore" wrote in message
...
Try this ...=IF(A1<=13,"A",IF(A1<1813,"RESULT",IF(A1=18," B","")))

"Danny" wrote:

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(A113<18,"RESULT",IF(A1=18,"B") ))
Danny

Excel Problem
 

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

"Danny" wrote:

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

"John Moore" wrote:

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

"Danny" wrote:

Have at it guys.
Im 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(A113<18,€�RESULT€�,IF(A1 =18,€�B€�)))
Danny