Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

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)
Solution

@ang_89 

 

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

 

Does this formula return the intended result?

Yes, that works! Thanks so much!
1 best response

Accepted Solutions
best response confirmed by ang_89 (Copper Contributor)
Solution

@ang_89 

 

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

 

Does this formula return the intended result?

View solution in original post