Check your calculations; cell P2 is calculated one way, but cell P5 is calculated differently:
You have in cell P5:
=(F5/21*31)+(G5/4*30)
which becomes >70k. The 2 cells for March and April contain 7k and 8k, which only add up to 15k. How can you get 70k from those 2 cells?
I think your formula in cell P56 should be:
=(F5/31*22)+(G5/30*4)
which calculates to 6,034.41 , is that correct?
|