Forum Discussion
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!...
Carole1026 Would this one do what you want?
=ROUNDUP(IF(C6<A6,1,C6/A6),0)
Carole1026 Would this one do what you want?
=ROUNDUP(IF(C6<A6,1,C6/A6),0)
Yes perfect! Many thanks for your efficient help, it does the trick perfectly.
🙂
yours,
