Hi,
Please see attached doc, I'm very much a learner and cant work out why cell F11 is adding total £6.89
Thanks
Hi,
Please see attached doc, I'm very much a learner and cant work out why cell F11 is adding total £6.89
Thanks
Because D11 and E11 are not EXACTLY what they appear to be
You have them formatted to show only 2 decimals, but they actually contain more than 2 decimal values.
The formula in F11 (or any formula) doesn't care how your cells are formatted, they only see the actual values contained in the cells.
See here with those cells formatted to show more decimals.
EFSnappyfish.xlsx
To resolve, apply the round function to the formulas in D11 and E11
D11: =ROUND(SUM($E$6)+($E$7*K11),2)
E11: =ROUND(SUM($E$5)+(K11*$E$4),2)
Last edited by Jonmo1; 02-26-2015 at 11:16 AM.
Excellent, Thanks. Great help on this forum!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks