|
if statement confusion
Hello all,
I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
=IF(C25=50000,.03*C25,.02*C25)
-- Gary''s Student - gsnu200750 "CV" wrote: Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
=IF(C25=50000,C25*3%,C25*2%)
Your second example should return "take me to dinner" if C50 is formatted to % and is less than 88% Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 09:51:00 -0700, CV wrote: Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
Ok thank for the response. So the below statement states shows how much
commission the sales person will earn. How do you create the IF function to state the actual commission rate. I included the below to show the formatting. I assume the first part of the statement will populate the commission rate field and the second will populate the amount Commission rate Commission Baker $55,600 $- "Gary''s Student" wrote: =IF(C25=50000,.03*C25,.02*C25) -- Gary''s Student - gsnu200750 "CV" wrote: Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
In commission rate column
=IF(C25=50000,"3%","2%") In commission column =IF(C25=50000,.03*C25,.02*C25) Gord On Sun, 21 Oct 2007 10:15:01 -0700, CV wrote: Ok thank for the response. So the below statement states shows how much commission the sales person will earn. How do you create the IF function to state the actual commission rate. I included the below to show the formatting. I assume the first part of the statement will populate the commission rate field and the second will populate the amount Commission rate Commission Baker $55,600 $- "Gary''s Student" wrote: =IF(C25=50000,.03*C25,.02*C25) -- Gary''s Student - gsnu200750 "CV" wrote: Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
Are you allowed to garner this type of assistance when completing your
homework?<g -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CV" wrote in message ... Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
Thanks, that makes perfect sense! I thought that I could write a IF statement
that did it all. Really appreciate the help. "Gord Dibben" wrote: In commission rate column =IF(C25=50000,"3%","2%") In commission column =IF(C25=50000,.03*C25,.02*C25) Gord On Sun, 21 Oct 2007 10:15:01 -0700, CV wrote: Ok thank for the response. So the below statement states shows how much commission the sales person will earn. How do you create the IF function to state the actual commission rate. I included the below to show the formatting. I assume the first part of the statement will populate the commission rate field and the second will populate the amount Commission rate Commission Baker $55,600 $- "Gary''s Student" wrote: =IF(C25=50000,.03*C25,.02*C25) -- Gary''s Student - gsnu200750 "CV" wrote: Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
I do not see why not. I'm still doing the work, just asking for help
understanding some of the steps. If I was in class I could ask the help of the teacher directly and get a similar explaination, or if this was a work task I could ask for help form a co-worker, or go to the lab. "Ragdyer" wrote: Are you allowed to garner this type of assistance when completing your homework?<g -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CV" wrote in message ... Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
So ... the title of your course is:
"How To Find Help" ???<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CV" wrote in message ... I do not see why not. I'm still doing the work, just asking for help understanding some of the steps. If I was in class I could ask the help of the teacher directly and get a similar explaination, or if this was a work task I could ask for help form a co-worker, or go to the lab. "Ragdyer" wrote: Are you allowed to garner this type of assistance when completing your homework?<g -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "CV" wrote in message ... Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
Hmm...I find it interesting that you are taking so much interest in my
questions. This is an online community where people can ask for help. If you look at the original example that was posted I also posted how I thought the IF statement worked and asked questions after getting responses. I'm trying to learn something new not just be lazy! You are being ridiculous and I do not appreciate having my time wasted. I would also assume that you never ask for help as apparently you find it wrong "Ragdyer" wrote: So ... the title of your course is: "How To Find Help" ???<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CV" wrote in message ... I do not see why not. I'm still doing the work, just asking for help understanding some of the steps. If I was in class I could ask the help of the teacher directly and get a similar explaination, or if this was a work task I could ask for help form a co-worker, or go to the lab. "Ragdyer" wrote: Are you allowed to garner this type of assistance when completing your homework?<g -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "CV" wrote in message ... Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
if statement confusion
I'm not looking to waste your time, so you don't have to bother to respond.
Of course, no one knows "everything"! Everyone, at one time or another, will find it necessary to seek help. However, within the implication of "taking a course" and "homework", there exists the connotation of *LEARNING*. In the REAL world of business, accuracy AND productivity exist hand-in-hand. Knowledge of a discipline contributes to both of these attributes. An IT department or a consulting firm that takes twice as long as expected to complete a project because they had to look up every aspect of the design, cannot look forward, with confidence, to increased salaries or being awarded additional contracts. The more you LEARN now, the less likely that you'll fall into those failing categories. Even in these groups, when you see suggestions posted in lower or proper case, you know that the respondents are so sure of their subject matter, that testing it in XL becomes unnecessary... and that is the prime example of accuracy AND productivity. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "CV" wrote in message ... Hmm...I find it interesting that you are taking so much interest in my questions. This is an online community where people can ask for help. If you look at the original example that was posted I also posted how I thought the IF statement worked and asked questions after getting responses. I'm trying to learn something new not just be lazy! You are being ridiculous and I do not appreciate having my time wasted. I would also assume that you never ask for help as apparently you find it wrong "Ragdyer" wrote: So ... the title of your course is: "How To Find Help" ???<bg -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "CV" wrote in message ... I do not see why not. I'm still doing the work, just asking for help understanding some of the steps. If I was in class I could ask the help of the teacher directly and get a similar explaination, or if this was a work task I could ask for help form a co-worker, or go to the lab. "Ragdyer" wrote: Are you allowed to garner this type of assistance when completing your homework?<g -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "CV" wrote in message ... Hello all, I'm struggling with IF statements. I have an example of a IF statement I'm trying to write. Any help would be great EX- sales amount exceeds $50,000 and the commision equals 3%, if less than $50,000 commision would equal 2%. =IF(C25=50000,"*3%",2%) I need the commision rate and actual commision. Right now all I get is the 3% commision rate. 2nd- Ex- If my grade is 88% or better my parents will give me $100 otherwise they will take me to dinner. Create an IF Function In cell D51 =IF(C50=88%,"$100","take me to dinner") My questions is when would it display "take me to dinner" vs "$100" currently the cell is showing $100. Thanks for the help |
| All times are GMT +1. The time now is 07:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com