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

[Carole1026]

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,

[#2 · Accepted solution]

@Carole1026 Would this one do what you want?

=ROUNDUP(IF(C6<A6,1,C6/A6),0)

[#3]

@Riny_van_Eekelen 

Yes perfect! Many thanks for your efficient help, it does the trick perfectly.

yours,