IF and then formulas

Copper Contributor

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 Replies
best response confirmed by ang_89 (Copper Contributor)





Does this formula return the intended result?

Yes, that works! Thanks so much!