Excel 2007 : Age IF Statement

[BG2010]

I'm trying to determine pricing based on age...An example for one that I have is

If the person is under 18, display $10...If older, display blank
=IF(I2<18, "$10", "")

I'm trying to figure out a range though...It needs to be "If the person is over is or is older than 18, but 64 or younger, display $15"

Any help is appreciated!

[TMS]

=if(and(i2>=18, i2<=64), "$15", "")

[daddylonglegs]

The first IF will capture all ages < 18 so you can just test for < 65, i.e.

=IF(I2<18,10,IF(I2<65,15,""))

Note that it's generally better to have the formula return just a number, you can format the cell to display that as currency

[TMS]

If you want to do arithmetic with the value, you'd be better formatting the cell as dollars and using:

Please Login or Register  to view this content.

Regards