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

New Contributor



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 Replies
best response confirmed by allyreckerman (Microsoft)

@Carole1026 Would this one do what you want?




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