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...
Greetings!
=IF(AND(C2>B2,(C2-B2)+A2>8),8,(C2-B2)+A2)
where,
A2=R121
B2=S120
C2=U120