ISBTECH
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks both of you that worked great!
Any particular reason for not splitting the points equally..if both the suggestions work for you..??
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
ASKER
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.
lets say you have value in a1 then...
=if(a1=<2000000,a1*.5,if(a
Saurabh...