Forum Discussion

ang_89's avatar
ang_89
Copper Contributor
Sep 11, 2023

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?

Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Sep 11, 2023

    ang_89 

     

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

     

    Does this formula return the intended result?

    • ang_89's avatar
      ang_89
      Copper Contributor
      Sep 11, 2023
      Yes, that works! Thanks so much!