Forum Discussion
Solved
Rounding a result
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 wh...
=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"
=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!!!
