I'm trying to do something fairly basic but I'm new to excel and am hitting a problem.
Below are a couple of images to explain what's happening, the bottom is just the same situation but with the formulas showing.
I am taking a total A (row 130) then subtracting a number from elsewhere (row 132) to get a new total B (row 133)
I want to then calculate 28.6% of this new total B for my final, everything works fine until I multiply total B by 0.286 (row 135) after that my final total is always 0.286 no matter what numbers sit in the previous boxes.
I've tested the multiply function elsewhere by multiplying a running total by 0.286 and it comes out fine but I then subtracted a number from the running total first then multiplied that answer by 0.286 and got the same problem as here so it's not an issue with this cell it's a problem with this list of commands. Is there a limit on how many times you can feed the answer of a function into another function before hitting problems or am I just doing something stupid here?
Hope I've explained clearly, if not feel free to ask anything.
Excel 02.JPG
Excel 01.JPG
Bookmarks