+ Reply to Thread
Results 1 to 3 of 3

ASAP HELP NEEDED ranges for a tax bracket

  1. #1
    Registered User
    Join Date
    09-06-2006
    Posts
    3

    ASAP HELP NEEDED ranges for a tax bracket

    hey every1 tried looking around for this but couldnt find it pls help if you got any idea's


    if c6 is less than 200 then 0%, if c6 is between 200 and 600 then 25%, if c6 is between 600 and 1000 then 40%, if c6 is above 1000 then 50%

    im stuck on

    IF(c6<200, 0, OR(c6>200, c6<600) then 25%) ---and so on for other ranges ah if then elseldsahfashf;

    AHHHHHHHHHHHHHH HELPPPPPPPPPPPPPPPPPP

  2. #2
    Registered User
    Join Date
    09-06-2006
    Posts
    3

    as far as i am

    =if(c6<200,0%,if(or(c6>200,c6<600),25%,if(or(c6>600,c6<1000),40%,if(or(c6>1000),50%))))

  3. #3
    Registered User
    Join Date
    09-06-2006
    Posts
    3

    thanx

    well thanx to all of yous i finally got it cheers!

    for anyone who perhaps DIDNT know it:=
    =IF(C6<200,0%,IF((AND(C6>200,C6<600)),25%,IF((AND(C6>600,C6<1000)),40%,IF(C6>1000,50%,0))))

+ 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