Ok so what I am trying to do is I have a spreadsheet that has a sumif function in it based on different category names, what I want to do is if that column gets over a certain amount I want to take that value and subtract it from another cell.
Column A Column B
Utilities 300.00
Rent 500.00
The threshold for utilites is $300 so if it goes over that say to $350 the value for rent should drop to $450
I did try to write a simple formula but I'm missing something, here is the formula I wrote: =IF((B3>300),(=sum(B4-B3)))
Bookmarks