jerickson3
New Member
- Joined
- Nov 4, 2005
- Messages
- 2
I am working on a spreadsheet where I want the answer/sum that comes from my formula to round up to a divisable of 5...but only if the answer/sum is higher than a certain number. Let's say 35. I can do the MROUNDs easily, I just can't figure out how to implement the certain number restriction. I don't want it to round up/down like that if the answer/sum is below 35. The formula to get the answer/sum is already pretty big using IF, LOOKUPS, and ROUNDS...so the simpler the better.
Thanks!
Thanks!