Excel rounding formulas

Question

Hi,

I need to create a rounding rule that rounds up to either 50 or 90. I've tried with CEILING but I don't know how to input multiple rules.
Any advice will be much appreciated.

/Anne

Answer 1

Hi @Anne Ryder ,

Something here might help:

ROUND function
https://support.microsoft.com/en-us/office/round-function-c018c5d8-40fb-4053-90b1-b3e7f61a213c

How to use the Excel ROUND function
https://exceljet.net/excel-functions/excel-round-function

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon

Answer 2

Hi @Anne Ryder ,
Could you provide a sample about your problem?
Based on your description, I suggest you refer to this article about ROUND function in Excel:
https://www.ablebits.com/office-addins-blog/2015/08/06/excel-round-functions/
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
Try to check if this will help you and please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.