# Thread: Formula for when a number is greater than or less than by a certain value Thanks: 0 Likes:  1 Post #5338641 (1)

1. ## Formula for when a number is greater than or less than by a certain value

Hello all

I am stuck with what seems a fairly simple thing to do but my tiny brain has given up now.

So I want to create an IF statement to work out IF a value in the same column is less than another value in the same column by 2, 3, 4 etc., any number really.

so my column looks like this:

2.84
3.85
5.00
13.50

What I want to do is when the second number in this case 3.85 is less than the third number 5.00 by 2

I can't seem to figure it out for the life of me.

Any ideas

The numbers will always be in the one column.

2. ## Re: Formula for when a number is greater than or less than by a certain value

Do you need something like this?

 B C 2 2.84 no 3 3.85 no 4 5.00 is less by 2 5 13.50 no

 Cell Formula C2 =IF(B2

3. ## Re: Formula for when a number is greater than or less than by a certain value

That really works thank you.

I did have that kind of idea but it just seemed way too simple.

Thanks again

Paul