Forum Discussion

Copper Contributor

Oct 12, 2021

Solved

IFS formula How can I round up to the nearest whole number?

Hello,

I am struggling with the following: I need a formula to round up to the nearest whole number.

I have been trying with IFS function, with no luck.

Can you please help?

Many thanks!

Kind regards,

Question-support.xlsx15 KB

Formulas and Functions

Riny_van_Eekelen
Oct 12, 2021
Carole1026 Would this one do what you want?
=ROUNDUP(IF(C6<A6,1,C6/A6),0)

2 Replies

Riny_van_Eekelen
Platinum Contributor
Oct 12, 2021
Carole1026 Would this one do what you want?
=ROUNDUP(IF(C6<A6,1,C6/A6),0)
- Carole1026
  Copper Contributor
  Oct 15, 2021
  Riny_van_Eekelen
  
  Yes perfect! Many thanks for your efficient help, it does the trick perfectly.
  🙂
  yours,

Resources