The function andif is not known to me
but if you like you can do it like this:
i always use nested formula's

=IF(AND(0.01<=B1,B1<=0.99),A1*0.2,IF(AND(1<=B1,
B1<=9.99),A1*0.4,IF(AND((10<= B1), (B1<=24)),A1*0.6,"out of range")))

and if you would like to add a 4th range you can type the formula instead of
"out of range"

IF(AND(25<=B1,B1<=49.99),A1*0.8,"out of range")

and of course instead of the fixed limits 0.01, 0.99 etc and the percentages
0.2, 0.4 etc. you can enter cells with a variable in it

With kind regards,
JW

"Stumblee" wrote:

I have been trying the IF formula and i am stuck.

EX. if(logic,true,false)got that
a1=1
a2=$20

IF(.01<=a2<=.99,a1*.2,0)andIF(1<=a2<=9.99,a1*.4,0) andIF(10<=a2<=24.99,a1*.60,0).................

i cant figure a formula
help please
plus if a2=1-25 at 5.25%,if a2=25.01-50 than 25 at 5.25%plus 25.01-50 at
3.75%...................
--
or a book with diff formulas
Brian