Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default If Formula Question (Can I have more than one result?)

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default If Formula Question (Can I have more than one result?)

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default If Formula Question (Can I have more than one result?)

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default If Formula Question (Can I have more than one result?)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 04:36 AM
user form question: text box to display result BigPig Excel Worksheet Functions 0 February 25th 06 09:17 PM
Another #N/A Result question...Sorry Steve K Excel Worksheet Functions 4 November 9th 05 10:47 AM
Median result used in formula gives incorrect result vlatham Excel Worksheet Functions 4 September 21st 05 05:26 PM
Cell / Date Formatting Question when result = -0- seve Excel Discussion (Misc queries) 3 January 17th 05 03:29 AM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"