Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've searched the forum for the answer to this question, and I know it can be
done, I just haven't done it in a long time. I'm trying to create a conditional formula that will allow me to have more than one result. This is for tracking bonuses for the salespeople in our company. For example, I want to have a column with the salesperson's name, then a column where I will input their sales figures. I'd like for the bonus column to auto fill with the desired amount. For example, less than $1000 results in no bonus, between $1000 and $5000 is a $100 bonus, et cetera. Is this possible? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Use VLOOKUP() with a small table.
-- Gary''s Student gsnu200709 "JacobMGross" wrote: I've searched the forum for the answer to this question, and I know it can be done, I just haven't done it in a long time. I'm trying to create a conditional formula that will allow me to have more than one result. This is for tracking bonuses for the salespeople in our company. For example, I want to have a column with the salesperson's name, then a column where I will input their sales figures. I'd like for the bonus column to auto fill with the desired amount. For example, less than $1000 results in no bonus, between $1000 and $5000 is a $100 bonus, et cetera. Is this possible? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes, by using nested IF statements. Assuming the sales figure is in A1, the
formula below will return 0 if <1000, 100 if between 1000 and 5000, and 200 if 5000 =IF(A1<1000, 0, IF(AND(A1=1000,A1<=5000), 100, 200)) "JacobMGross" wrote: I've searched the forum for the answer to this question, and I know it can be done, I just haven't done it in a long time. I'm trying to create a conditional formula that will allow me to have more than one result. This is for tracking bonuses for the salespeople in our company. For example, I want to have a column with the salesperson's name, then a column where I will input their sales figures. I'd like for the bonus column to auto fill with the desired amount. For example, less than $1000 results in no bonus, between $1000 and $5000 is a $100 bonus, et cetera. Is this possible? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
But you can omit the AND(A1=1000,... as you've already tested for the
contrary condition. You can simplify to =IF(A1<1000, 0, IF(A1<=5000, 100, 200)) -- David Biddulph "Vergel Adriano" wrote in message ... Yes, by using nested IF statements. Assuming the sales figure is in A1, the formula below will return 0 if <1000, 100 if between 1000 and 5000, and 200 if 5000 =IF(A1<1000, 0, IF(AND(A1=1000,A1<=5000), 100, 200)) "JacobMGross" wrote: I've searched the forum for the answer to this question, and I know it can be done, I just haven't done it in a long time. I'm trying to create a conditional formula that will allow me to have more than one result. This is for tracking bonuses for the salespeople in our company. For example, I want to have a column with the salesperson's name, then a column where I will input their sales figures. I'd like for the bonus column to auto fill with the desired amount. For example, less than $1000 results in no bonus, between $1000 and $5000 is a $100 bonus, et cetera. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
user form question: text box to display result | Excel Worksheet Functions | |||
Another #N/A Result question...Sorry | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Cell / Date Formatting Question when result = -0- | Excel Discussion (Misc queries) |