Forum Discussion
Excel 2016 IF Nested question
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 t...
Hi Rory,
Not sure what exactly is your function, but in general
=MIN(<function result>,8)
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.