Not sure if this is possible. I am looking for a formula that if I input a number in cell B4 the cell below will automatically do the calculations below based on the size of the number in B4. For instance if I input 175,000 in B4 the formula will take 175 * 4.25 + 1,112.50 + 4.50 * 175 + 87.50
150,000 - 250,000 Mulitply by $4.25 per thousand and add $1,112.50 to total + Multiply by $4.50 per thousand and add $87.50 to total
250,000 - 500,000 Multiply by $3.50 per thousand and add $1,300.00 to total + Multiply by $3.50 per thousand and add $37.50 to total
500,000 - 10,000,000 Multiply by $3.25 per thousand and add $1,425.00 to total + Multiply by $2.75 per thousand and add $12.50 to total
Bookmarks