Forum Discussion

ang_89's avatar
ang_89
Copper Contributor
Sep 11, 2023
Solved

IF and then formulas

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?

Resources