Dear All,
Please help me if anyone can.
In my excel column no O17 amount is 16937 when I convert in 1000 format it just comes 17 and column no N17 amount is 71800 when it convert to 1000 format it comes 71.8. In column O18 I just enter equation
=(O17*4)/N17-1 the figure which I got is 94320% but actual it must be -5%. I don't know what reason amount showing wrongly. Please help me if someone knows the reason
. I attach my excel sheet.
Please help me if anyone can.
In my excel column no O17 amount is 16937 when I convert in 1000 format it just comes 17 and column no N17 amount is 71800 when it convert to 1000 format it comes 71.8. In column O18 I just enter equation
=(O17*4)/N17-1 the figure which I got is 94320% but actual it must be -5%. I don't know what reason amount showing wrongly. Please help me if someone knows the reason
Attachments
-
274.6 KB Views: 12