SOLVED

Rounding a result

%3CLINGO-SUB%20id%3D%22lingo-sub-3010436%22%20slang%3D%22en-US%22%3ERounding%20a%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010436%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20following%20formula%20in%20my%20Excel%20(Office%20365)%20Budget%20file%20(%3DIFS(G5%3D7%2CI45%2CG5%3D8%2CJ45%2CG5%3D9%2CK45%2CG5%3D10%2CL45%2CG5%3D11%2CM45%2CG5%3D12%2CN45)%26amp%3B%22%20Due%22)%3C%2FP%3E%3CP%3Ewhich%20has%20been%20working%20great%20for%20my%20needs.%20However%2C%20today%20when%20I%20opened%20the%20file%2C%20the%20result%20is%20being%20shown%20with%2013%20digits%20(ex%3A%20%24123.4599999999999)%20after%20the%20decimal%20point%20(it%20hadn't%20been%20doing%20that%20before).%20I%20need%20to%20know%20how%20to%20round%2C%20preferabbly%20up%2C%20to%202%20digits%20(ex%3A%20%24123.46).%20I've%20tried%20diff%20formatting%20and%20nothing%20seems%20to%20change%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS%3A%20(G5%20is%20the%20number%20of%20the%20month%20%26amp%3B%20(I%20-%20N%2045)%20is%20a%20cash%20value%20that%20is%20diff%20in%20each%20month).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3010436%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3010460%22%20slang%3D%22en-US%22%3ERe%3A%20Rounding%20a%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010460%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684000%22%20target%3D%22_blank%22%3E%40dlcartin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DROUND(IFS(G5%3D7%2CI45%2CG5%3D8%2CJ45%2CG5%3D9%2CK45%2CG5%3D10%2CL45%2CG5%3D11%2CM45%2CG5%3D12%2CN45)%2C2)%26amp%3B%22%20Due%22%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%3DROUND(INDEX(C45%3AN45%2CG5)%2C2)%26amp%3B%22%20Due%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have the following formula in my Excel (Office 365) Budget file (=IFS(G5=7,I45,G5=8,J45,G5=9,K45,G5=10,L45,G5=11,M45,G5=12,N45)&" Due")

which has been working great for my needs. However, today when I opened the file, the result is being shown with 13 digits (ex: $123.4599999999999) after the decimal point (it hadn't been doing that before). I need to know how to round, preferabbly up, to 2 digits (ex: $123.46). I've tried diff formatting and nothing seems to change it.

 

PS: (G5 is the number of the month & (I - N 45) is a cash value that is diff in each month).

 

Thanks in advance!!!

2 Replies
best response confirmed by dlcartin (Contributor)
Solution

@dlcartin 

=ROUND(IFS(G5=7,I45,G5=8,J45,G5=9,K45,G5=10,L45,G5=11,M45,G5=12,N45),2)&" Due"

or

=ROUND(INDEX(C45:N45,G5),2)&" Due"

Worked perfectly!!!
Thank you!!!