+ Reply to Thread
Results 1 to 2 of 2

if statement question

  1. #1
    Registered User
    Join Date
    04-07-2006
    Posts
    14

    if statement question

    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.

  2. #2

    Re: if statement question

    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,""))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1