Using multiple ranges in one fuction

[apar93]

I need help putting together an IF(AND( formula that allows for multiple ranges.
...............1ST 2ND 3-5 6-10
3 X 5 ..... $100 $60 $35 $30

FOR 3-5 I tried: IF(AND(A76="3X5",B76>=3,B76<=5),((B76-2)*35)+160) which worked! But when I tried the second range 6-10 it said invalid. Help please!!!

 

[Scott Huish]

What are you trying to do with this exactly? Nested IFs may not be the best answer depending on what you are trying to do. Where in that sample is B76, it looks like it should be $100 but that doesn't match up to your 3-5 range in your AND statement.