Excel 2016 IF Nested question

[Rory Majors]

I have tried to input this multiple ways but seem to be missing something. I have a function (U120>S120,0,S120-U120)+R121. in a cell and need to add to it that if the entirety of the function is >8 then it will be limited to 8 and if it is less than 8 then it will show the true value of the function

[#2]

Hi Rory,

Not sure what exactly is your function, but in general

=MIN(<function result>,8)

[#3]

My terminology is probably off. What I am trying to say is I get a number from (U120>S120,0,S120-U120)+R121. I want it to display 8 if the result of the number is greater than 8. If it is lower than 8 I want it to read the result of the equation.

[#4]

I am assuming this can be done all in one cell but am having trouble trying to figure out the way to input it. I do not want to have a separate cell with =IF(U121>S121,0,S121-U121)+R122 in it and see if I can have that included in the IF equation.

[#5]

Like this?

=MIN(IF(U121>S121,0,S121-U121)+R122,8)

[#6]

Greetings!

=IF(AND(C2>B2,(C2-B2)+A2>8),8,(C2-B2)+A2)

where,

A2=R121

B2=S120

C2=U120