SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2838346%22%20slang%3D%22en-US%22%3EIFS%20formula%20How%20can%20I%20round%20up%20to%20the%20nearest%20whole%20number%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2838346%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20with%20the%20following%3A%20I%20need%20a%20formula%20to%20round%20up%20to%20the%20nearest%20whole%20number.%3C%2FP%3E%3CP%3EI%20have%20been%20trying%20with%20IFS%20function%2C%20with%20no%20luck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2838346%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2838661%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20formula%20How%20can%20I%20round%20up%20to%20the%20nearest%20whole%20number%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2838661%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1183305%22%20target%3D%22_blank%22%3E%40Carole1026%3C%2FA%3E...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DMAX(1%2C%20ROUNDUP(C6%2FA6%2C%200))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20C6%20and%20A6%20are%20never%20negative%2C%20%3DROUNDUP(C6%2FA6%2C%200)%20might%20suffice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20is%20it%20okay%20to%20return%20zero%20when%20C6%20is%20zero%3F%26nbsp%3B%20Your%20original%20IF%20expression%20would%20return%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2838610%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20formula%20How%20can%20I%20round%20up%20to%20the%20nearest%20whole%20number%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2838610%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1183305%22%20target%3D%22_blank%22%3E%40Carole1026%3C%2FA%3E%26nbsp%3BWould%20this%20one%20do%20what%20you%20want%3F%3C%2FP%3E%3CP%3E%3DROUNDUP(IF(C6%3CA6%3E%3C%2FA6%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2849329%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20formula%20How%20can%20I%20round%20up%20to%20the%20nearest%20whole%20number%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2849329%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20perfect!%20Many%20thanks%20for%20your%20efficient%20help%2C%20it%20does%20the%20trick%20perfectly.%3C%2FP%3E%3CP%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3Eyours%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

@Carole1026 Would this one do what you want?

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

@Riny_van_Eekelen 

 

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

yours,