Hi,
I am trying to create a calculator that I can put in a number in cells B3 and B4 and it will calculate the right price. However, the price is based on a tiered system and at a certain tier there are free users. I want the calculator to provide the right number of free users (cell B16) based on input from cell B3, but if there is nothing, or too low of a number in cell B4, cell B16 will be 0. I want it to recognize that if I have 2 in cell B4, B16 will also only be 2. But if I have 10 in B4, then B10 would be 2, 3, or 5. Right now, my input for cell B4 is 2, so cell B16 should also be 2, but the formula is giving me 5 because of my input in cell B3.
This is the formula I am working with for cell B16:
=IF(B4<2,0,IF(AND(B3>=A11,B3<=B11),2,IF(AND(B3>=A12,B3<=B12),3,IF(B3>=A13,5,IF(B3<=B10,0,)))))
Bookmarks