IF function not working

[Soni]

I may be writing this incorrectly but please help -

=IF(c3<=1000,*.05)OR(c3>=1001 BUT <=3999, *.10)OR(c3>=4000, *.125)

Basically, if cell C3 is equal to or less than 1000, multiply the amount in
C3 by .05 OR if C3 is greater than or equal to 1001 BUT less than or equal to
3999, multiply by .10 OR if C3 is greater than or equal to 4000 then multiply
C3 by .125

What am I doing wrong?

Soni

 

[Glenn]

I may be writing this incorrectly but please help -

=IF(c3<=1000,*.05)OR(c3>=1001 BUT <=3999, *.10)OR(c3>=4000, *.125)

Basically, if cell C3 is equal to or less than 1000, multiply the amount in
C3 by .05 OR if C3 is greater than or equal to 1001 BUT less than or equal to
3999, multiply by .10 OR if C3 is greater than or equal to 4000 then multiply
C3 by .125

What am I doing wrong?

Soni

=IF(C3<=1000,C3*0.05,IF(C3<=3999,C3*0.1,C3*0.125))

 

[John C]

=C3*0.05+(C3>=1000)*(C3*0.05)+(C3>=4000)*(C3*0.025)