I want to write a formula that changes when the previous column reaches a certain amount. I assume it can be done using SUMIF but thats where my knowledge ends.
Example. B2 is SUM(A2*.45) , B3 is SUM(A3*.45) and B4 is SUM(A4*.25)
What i need to do is create a formula that changes the *.45 to *.25 when the previous column reaches 10000.
Thanks for any help.