cost according to square foot ????

[RoyS]

What am i doing wrong? Finding cost in a range of Sq. Ft. sizes.
If x is < 32sq ft but > 16 sq ft then $16.00
if x is > 8sq ft but < 16 sq ft then $12.00
if x is > 4sq ft but < 8 sq ft then $10.00
if x is > 0 sq ft but < 4 sq ft then $6.00

What is wrong in my formula?
=IF(E4>16,"$16",IF(E4>8<=16,"$12",IF(E4>4<=8,"$10",IF(E4>0<=4,"$6",""))))

Thanks - Roy

 

[wigi]

For instance

=IF(E4>16,16,IF(E4>8,12,IF(E4>4,10,IF(E4>0,6,""))))

 

[p45cal]

untested:
=IF(E4>16,"$16",IF(E4>8,"$12",IF(E4>4,"$10",IF(E4>0,"$6",""))))
though ifyou need to do calculatiopn with the result, lose the quotes and the $ symbols:
=IF(E4>16,16,IF(E4>8,12,IF(E4>4,10,IF(E4>0,6,""))))
and format the result as currency.

 

[RoyS]

wigi - thank you. I am open to suggestions on a more meaning full title. Thanks again.

 

[RoyS]

p45cal - thanks for the feedback. Roy

 

[wigi]

wigi - thank you. I am open to suggestions on a more meaning full title. Thanks again.

Your topic title is not too bad, the message in my signature is a general one and not about your title. Although the question marks can be removed