Need a formula for subtracting a number only if it is greater than or equal to 5...

[Timberjeremy]

Please help me with a formula for a spreadsheet I am creating for work purposed. I Need a formula for subtracting 2 only if it is greater than or equal to 5, subtracting 3 if it is greather than or equal to 9, and subtracting 4 if it is greater than or equal to 13

Not sure if this is possible and I am not an excel genius


Any and all help/feedback is appreciated. Thanks in advance!

[FDibbins]

Hi, welcome to the forum

I assume the "it"..."subtracting 2 only if it is greater than or equal to 5" refers to another cell? If so, then maybe something like this....

subtracting 2 only if it is greater than or equal to 5,
subtracting 3 if it is greather than or equal to 9, and
subtracting 4 if it is greater than or equal to 13

=A1-if(A1>=13,4,if(A1>=9,3,if(A1>=5,2,0)))

[FDibbins]

Here is a shorter version...
=A1-(2+INT((A1-5)/4))

[Timberjeremy]

Thanks for getting back so quick!!! I am going to try these tomorrow and will let you know if they work for my spreadsheet

[FDibbins]

I look forward to your feedback

[Timberjeremy]

Hi, welcome to the forum

I assume the "it"..."subtracting 2 only if it is greater than or equal to 5" refers to another cell? If so, then maybe something like this....

=A1-if(A1>=13,4,if(A1>=9,3,if(A1>=5,2,0)))

I also forgot one parameter/condition
I also the equation to subtract 1 if the desired cell is less than or equal to 4

[FDibbins]

Just change the last parameter of the IF statement....
=A1-if(A1>=13,4,if(A1>=9,3,if(A1>=5,2,1)))

[Timberjeremy]

Awesome, Headed into work shortly and will be able to test it out! Thanks

[Timberjeremy]

It worked! thanks alot, im sure i will be needing some more help as I put the final touches on the spreadsheet and eventually make more! Thanks again

[FDibbins]

Happy to help, look forward to assisting you further

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)