i need a formula that would round up and down to a certain number
for example if cell a2 is greater than 25 (like 30) it should roundown to 25, if its lower than 15 (like 11) it should roundup to 15, if its 18 it should not change
meaning only numbers that are out of my range (between 15-25) should change to closest low or high number
you can probably do it with a different formula
BUT I would do
=IF( a2>25, 25, IF( A2<15, 15, A2))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
just for fun
Formula:
Please Login or Register to view this content.
etaf's formula is for sure better.
Cheers
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks