if statement question

  • Thread starter Thread starter SMAlvarez
  • Start date Start date
S

SMAlvarez

How do I do this using an if statement in excel?

If the amount is from 15000-350000 then the tax is .23, if its extactly
350000 then its .15

What I really need to know if theres something similar to "to" in the
if statement.

For example 15000 to 350000

like in a c++ switch statement.
 
Assuming there isn't more to it than that...like <150000 or greater than
350000.

(A1 is the target cell, this is set to have anything less than 150k to show
a blank, and there is nothing for anything greater than 350000!)

=IF((AND(A1>150000,A1<350000)),A1*0.23,IF(A1=350000,A1*0.15,""))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Excel 2007 Nested "If" Statement to Excel 2003: Overcom 4
help with syntax for if and statement 3
Segregate Outstanding Payment 1
IF and OR question 5
How do I get expression code help? 4
Nested IF Statements 1
with SP2, has the rand() function been slowed down ? 3
If Function 2

Back
Top