Hi,
I need a formula that will round a value up to the nearest multiple of 70.
For example, if cell A1 contains 59 then cell B1 would have a formula that rounded it up to 70. If cell A2 contains 139, then cell B2 would contain a formula that rounded it up to 140.
Here is a table showing what I am trying to do:
Values 1-70, then return 70
Values 71-141, then return 141
Values 142-212, then return 212
Values 213-283, then return 283
...
You will notice that there are only 69 values between 1-70, while all the other ranges contain 70 values.
Any help you can provide would be fantastic. Thank you!
-John
Bookmarks