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
  • Last Modified:

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
Asked:
ISBTECH
  • 3
  • 2
1 Solution
 
Saurabh Singh TeotiaCommented:
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
 
barry houdiniCommented:
You can do without the AND....
=if(a1<2000000,a1*0.5,if(a1=<2500000,a1*0.6,a1*0.65))
regards, barry
0
 
ISBTECHAuthor Commented:
Thanks both of you that worked great!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Saurabh Singh TeotiaCommented:
Any particular reason for not splitting the points equally..if both the suggestions work for you..??
0
 
Saurabh Singh TeotiaCommented:
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
 
ISBTECHAuthor 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

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