4halliwellt
New Member
- Joined
- Sep 30, 2016
- Messages
- 2
e.g. if value of B2 is between 0 and 500, round the number entered to the nearest 5,
if the value entered is between 500 and 1000, round the number to the nearest 10,
if the value entered is between 1000 and 2000, round the number to the nearest 25.
Many thanks.
if the value entered is between 500 and 1000, round the number to the nearest 10,
if the value entered is between 1000 and 2000, round the number to the nearest 25.
Many thanks.