IF function not working
 

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 function not working
 

Soni wrote:
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))

IF function not working
 

=C3*0.05+(C3=1000)*(C3*0.05)+(C3=4000)*(C3*0.025 )
--
** John C **

"Soni" wrote:

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 function not working
 

.... or =C3*(0.05+(C31000)*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.]
--
David Biddulph

"John C" <johnc@stateofdenial wrote in message
...
=C3*0.05+(C3=1000)*(C3*0.05)+(C3=4000)*(C3*0.025 )
--
** John C **

"Soni" wrote:

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