you might have to consider <= as well to include 10 and 15
--
paul
remove nospam for email addy!



"Elvin" wrote:

That was the trick. Thanks Paul!

"paul" wrote:

in cell B3 =if(x-y<10,1,if(x-y<15,2,3)).I have assumed your middle statement
is between 10 and 15 and your last statement is greater than 15.I cant make
sense otherwise
--
paul
remove nospam for email addy!



"Elvin" wrote:

I need to create a formula that outputs a 1, 2, or 3 based on the result of:

If the value of x-y <10 then cell B3 = 1, If the value of x-y<10 but 15
then cell B3 = 2, If x-y<15 then cell B3 = 3.

Can I do this with formulae or do I need to go to VBA, if I need to go to
VBA how is this calculated.