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)
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.
Like this?
=MIN(IF(U121>S121,0,S121-U121)+R122,8)
