Forum Discussion
Solved
Excel Functions Help Nested
I need the sum of 2 cells (C3+C5) If the sum is = or less than 4 I need the cell, (E3) to read 100% If the sum is =5 to or >9 I need the cell, (E3) to read 90% If the sum is =>10 or <19 I need the...
No need for the all the logical functions. Create a dedicated lookup table in your sheet with the rates then use XLOOKUP:
=LET(total,C3+C5,IF(total>250,"no such",XLOOKUP(total,value,rate,,-1)))
GOT IT!
Thanks for all of your help!
Thanks for all of your help!
You're welcome!