Lotus 123 @ROUNDM() formula adding multiple

  Ed747 20:47 07 Sep 03
Locked

When using the @ROUNDM() formula in my spreadsheets occasionally the formula decides to add the multiple I have chosen to round up by when the number doesn't need to be rounded as it is already a multiple of the required number for example : if I required a cells contents to be rounded up to the nearest multiple of 5 then entered 15 in that particular cell the formula would return 20 yet, 15 is already rounded to the nearest multiple of 5. Is anyone experiencing similar problems or can anyone provide a solution?

I use Excel, but from what you have said in your post, the function @ROUNDM() is behaving correctly in that it is taking your number 15 and rounding it up to the next multiple of 5, not the nearest but the next.

In Excel the function is RoundUp. If I wanted the nearest then I would need to use Round.

Check and see whether there is a similar function in your spreadsheet

HTH

  VoG II 21:54 07 Sep 03

I think that you need to use MROUND but I am not familiar with Lotus 123.

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Apple MacBook Pro with Touch Bar review

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…