View Single Post
 
Old 02-28-2022, 02:52 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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?
Reply With Quote