Sep 18 2019 02:54 PM
Trying to get a range function to multiple by designated amounts through cell values
IF(AND(D10<=24),B16*180, IF(AND(D10>=25, but D10=<36),B16*225, IF(AND(D10>=37, but D10=<48),B16*250, IF(AND(D10>=49, but D10=<60),B16*300, IF(AND(D10>=61),B16*350)))))
Sep 18 2019 03:44 PM
Perhaps it's better to use LOOKUP(), but if with IF
=B16*
IF(D10>=61,350,
IF(D10>=49,300,
IF(D10>=37,250,
IF(D10>=25,225,
180
))))