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