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)

 

[David Biddulph]

.... or =C3*(0.05+(C3>1000)*0.05+(C3>=4000)*0.025)
Taking the C3 outside, and removing the = from >=1000

[We note also that the OP didn't specify what to do with C3 values >1000 and
<1001, or >3999 and <4000.]