Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
• Status: Solved
• Priority: Medium
• Security: Public
• Views: 238

# create a formula that allows three options (if 1 then 2 or if 3 then 4 or if 5 then 6)

I am trying to create a formula that allows me to populate a cell with one of three options. Effectively I'm trying to multiply one cell (dollar amount of a particular sale) on the worksheet by .5 if a different cell (the total of all sales for the month) is less than \$2,000,000 or by .6 if between 2m and 2.5m or by .65 if over 2.5m.  A normal if formula doesn't give me enough options and I've never done any VB programing. Any ideas?
0
ISBTECH
• 3
• 2
1 Solution

Commented:
There you go you can use this if formula...which will do what you want...
lets say you have value in a1 then...
=if(a1=<2000000,a1*.5,if(and(a1>2000000,a1=<2500000),a1*.6,a1*65))
Saurabh...
0

Commented:
You can do without the AND....
=if(a1<2000000,a1*0.5,if(a1=<2500000,a1*0.6,a1*0.65))
regards, barry
0

Author Commented:
Thanks both of you that worked great!
0

Commented:
Any particular reason for not splitting the points equally..if both the suggestions work for you..??
0

Commented:
Sorry, I posted a little too quickly. I can see that Barry's formula is better than mine and that is why you selected it
0

Author Commented:
Actualy it had not occurred to me that I could split the points, I would have done so if I had thought about it, I will keep it in mind from now on.  Thanks.
0

## Featured Post

• 3
• 2
Tackle projects and never again get stuck behind a technical roadblock.