Struggling with IF statement

Copper Contributor

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)))))

1 Reply

@truckbox-us 

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
))))