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
|