4halliwellt
New Member
- Joined
- Sep 30, 2016
- Messages
- 2
Hello,
I asked a questions a few months back about rounding to meet certain values
https://www.mrexcel.com/forum/excel...cell-round-differing-degrees-based-range.html
I have a new query - I was wondering what I'd need to do to have a cell add 50, and round up to nearest 100 - based on the value of another cell.
E.g D3 is 5000 E3 should be 5100 (5000 + 50, then round up to nearest 100)
Thanks in advance!
I asked a questions a few months back about rounding to meet certain values
https://www.mrexcel.com/forum/excel...cell-round-differing-degrees-based-range.html
I have a new query - I was wondering what I'd need to do to have a cell add 50, and round up to nearest 100 - based on the value of another cell.
E.g D3 is 5000 E3 should be 5100 (5000 + 50, then round up to nearest 100)
Thanks in advance!