IF and then formulas

[ang_89]

I am trying to make a formula that states if column B is <=8 then Column B is 8, and then using column D with this formula =SUM(D11-B11). 

Is there a way to do it that will leave the original number in column B what I typed and not change it to an 8?

[#2 · Accepted solution]

@ang_89 

=D11-IF(B11<=8,8,B11)

Does this formula return the intended result?

[#3]

Yes, that works! Thanks so much!