# Multiple IF statement with 3 or more variables.

1. ## Multiple IF statement with 3 or more variables.

Here it is in a nutshell:

I have the following parameters that i must meet.

in cell A1 i have a value that is changing.

I want cell A2 to look at this value and determine what to do, it must meet the following things. I am thinking this can be done with an if statement but i am not sure exactly how.

if A1>600, A1*.02
If A1>399, A1*.03
If A1<400, 5.50

so basically what i am trying to do is look back at A1 and if the value falls between 399-599 multiply that value by 0.03, if the value is lower than 400 then report 5.50, if the value is 600 or greater then multiply by 0.02

2. ## Re: Formula problem

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

3. ## Re: Multiple IF statement with 3 or more variables.

Thanks. I re-titled the thread. I hope this fixes this issue.
Thanks again.

4. ## Re: Multiple IF statement with 3 or more variables.

rkm140,

Try:
=IF(A1>=600,A1*0.02,IF(A1<400,5.5,IF(A1>399,A1*0.03,"")))

5. ## Re: Multiple IF statement with 3 or more variables.

Try

=IF(A1>600,A1*0.02,IF(A1>399,A1*0.03,5.50)

6. ## Re: Multiple IF statement with 3 or more variables.

i tried both, in both cases it report 5.50 no matter what value appears in A1.

7. ## Re: Multiple IF statement with 3 or more variables.

=IF(A1+0>600,A1*0.02,IF(A1+0>399,A1*0.03,5.50)

8. ## Re: Multiple IF statement with 3 or more variables.

Thanks it worked.

9. ## Re: Multiple IF statement with 3 or more variables.

That means A1 is actually entered as a text string and not a number.

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

#### 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