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 num...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Sep 11, 2023

    ang_89 

     

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

     

    Does this formula return the intended result?

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!

Share

Resources