Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Can you use an IF statement with an already existing formula?
Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
A formula, prior to Excel 2007, can have up to 7 levels of functions, so yes
you can have an if with a formula. For example: =IF(D6/D76=10,SUM(A1:A30),SUM(A1:A10)) Hope this helps point you in the general direction... -- Kevin Backmann "AL" wrote: Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Can you explain?
-- Don Guillett Microsoft MVP Excel SalesAid Software "AL" wrote in message ... Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Hopefully this will help explain:
An IF statement is actually an IF, THEN, ELSE statement. Described in plain english the formula says: IF cell D6 / cell D76 = 10 THEN sum the values in cells A1 through A30 ELSE (if D6/D76 does not = 10) sum the values in cells A1 through A30 You don't have to use SUM for the then or else! Foir instance you can test a cell to see if it's greater than a value and return a letter. If(a150,"Pass","Fail") "Don Guillett" wrote: Can you explain? -- Don Guillett Microsoft MVP Excel SalesAid Software "AL" wrote in message ... Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
I have 3 columns **1 is best, 4 is worst
Rank Out of Percentage 3 4 25% When I set up the original formula to divide 3/4 I get 75%, which is not what I am looking for. So I set another column to take the 75% and subtract 100% to get the 25%. Well, when I have this example: Rank Out of Percentage 1 5 100% It should be 100%, but the formula returns 80% (1/5=20% minus 100%=80%) I was trying to set an IF statement within my formula if my rank column had a 1, then my percentage column would read 100%. I'm having difficulty since there is already a formula in the cell. Thanks! "Don Guillett" wrote: Can you explain? -- Don Guillett Microsoft MVP Excel SalesAid Software "AL" wrote in message ... Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Sorry, but I'm not understanding your scoring system. I think you've been
inconsistent, which is why you're not getting the answers you expect. If you want the Rank 1 to score 100%, and the separation to be 100% divided by the "Out of" figure, then wouldn't 2 out of 4 be 75%, and 3 out of 4 be 50% (not the 25% you quoted), then 4 out of 4 would be 25%. Of course if you want the 4 out of 4 to score 0, then you'd need the separation to be 1 divided by ("Out of" -1), or 33.3% in your case, not 25%, and that would give 100%, 66.7%, 33.3%, and 0% for your four scores. Tell us which system you are using, and then you or we can work out a simple formula. -- David Biddulph "AL" wrote in message ... I have 3 columns **1 is best, 4 is worst Rank Out of Percentage 3 4 25% When I set up the original formula to divide 3/4 I get 75%, which is not what I am looking for. So I set another column to take the 75% and subtract 100% to get the 25%. Well, when I have this example: Rank Out of Percentage 1 5 100% It should be 100%, but the formula returns 80% (1/5=20% minus 100%=80%) I was trying to set an IF statement within my formula if my rank column had a 1, then my percentage column would read 100%. I'm having difficulty since there is already a formula in the cell. Thanks! "Don Guillett" wrote: Can you explain? -- Don Guillett Microsoft MVP Excel SalesAid Software "AL" wrote in message ... Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
What is more confusing is that it is Out of 4 in one case and Out of 5
in the other. Pete On Oct 26, 7:25 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Sorry, but I'm not understanding your scoring system. I think you've been inconsistent, which is why you're not getting the answers you expect. If you want the Rank 1 to score 100%, and the separation to be 100% divided by the "Out of" figure, then wouldn't 2 out of 4 be 75%, and 3 out of 4 be 50% (not the 25% you quoted), then 4 out of 4 would be 25%. Of course if you want the 4 out of 4 to score 0, then you'd need the separation to be 1 divided by ("Out of" -1), or 33.3% in your case, not 25%, and that would give 100%, 66.7%, 33.3%, and 0% for your four scores. Tell us which system you are using, and then you or we can work out a simple formula. -- David Biddulph "AL" wrote in message ... I have 3 columns **1 is best, 4 is worst Rank Out of Percentage 3 4 25% When I set up the original formula to divide 3/4 I get 75%, which is not what I am looking for. So I set another column to take the 75% and subtract 100% to get the 25%. Well, when I have this example: Rank Out of Percentage 1 5 100% It should be 100%, but the formula returns 80% (1/5=20% minus 100%=80%) I was trying to set an IF statement within my formula if my rank column had a 1, then my percentage column would read 100%. I'm having difficulty since there is already a formula in the cell. Thanks! "Don Guillett" wrote: Can you explain? -- Don Guillett Microsoft MVP Excel SalesAid Software "AL" wrote in message ... Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
I apologize for any confusion. I am ranking sorority chapters on Greek
campuses... Example: If the Alpha Chapter on University Campus is ranked #1 out of the other 5 sororities, then Alpha Chapter is the best on campus. 100% If Beta Chapter on College Campus is ranked #3 out of the other 4, they are in the 25 percentile. If the Gamma Chapter on Tech Campus is ranked # 8 out of the other 8 sororities, they are the worst on the campus giving them a 0%. I hope this helps. "David Biddulph" wrote: Sorry, but I'm not understanding your scoring system. I think you've been inconsistent, which is why you're not getting the answers you expect. If you want the Rank 1 to score 100%, and the separation to be 100% divided by the "Out of" figure, then wouldn't 2 out of 4 be 75%, and 3 out of 4 be 50% (not the 25% you quoted), then 4 out of 4 would be 25%. Of course if you want the 4 out of 4 to score 0, then you'd need the separation to be 1 divided by ("Out of" -1), or 33.3% in your case, not 25%, and that would give 100%, 66.7%, 33.3%, and 0% for your four scores. Tell us which system you are using, and then you or we can work out a simple formula. -- David Biddulph "AL" wrote in message ... I have 3 columns **1 is best, 4 is worst Rank Out of Percentage 3 4 25% When I set up the original formula to divide 3/4 I get 75%, which is not what I am looking for. So I set another column to take the 75% and subtract 100% to get the 25%. Well, when I have this example: Rank Out of Percentage 1 5 100% It should be 100%, but the formula returns 80% (1/5=20% minus 100%=80%) I was trying to set an IF statement within my formula if my rank column had a 1, then my percentage column would read 100%. I'm having difficulty since there is already a formula in the cell. Thanks! "Don Guillett" wrote: Can you explain? -- Don Guillett Microsoft MVP Excel SalesAid Software "AL" wrote in message ... Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
No. It doesn't help at all. Perhaps you didn't read my message.
#1 out of 4 scores 100% You say that #3 out of 4 scores 25% Presumably #4 out of 4 scores 0% But what does #2 out of 4 score ? [In your original formula you were trying a linear relationship, but you obviously haven't got a linear relationship as there is a 3 times difference of output for two steps of input (from 1 to 3) compared with one step of input (from 3 to 4).] #1 out of 5 scores 100% #5 out of 5 scores 0% Tell us what #2 out of 5 scores, and what #3 out of 5 scores, and #4 out of 5? -- David Biddulph "AL" wrote in message ... I apologize for any confusion. I am ranking sorority chapters on Greek campuses... Example: If the Alpha Chapter on University Campus is ranked #1 out of the other 5 sororities, then Alpha Chapter is the best on campus. 100% If Beta Chapter on College Campus is ranked #3 out of the other 4, they are in the 25 percentile. If the Gamma Chapter on Tech Campus is ranked # 8 out of the other 8 sororities, they are the worst on the campus giving them a 0%. I hope this helps. "David Biddulph" wrote: Sorry, but I'm not understanding your scoring system. I think you've been inconsistent, which is why you're not getting the answers you expect. If you want the Rank 1 to score 100%, and the separation to be 100% divided by the "Out of" figure, then wouldn't 2 out of 4 be 75%, and 3 out of 4 be 50% (not the 25% you quoted), then 4 out of 4 would be 25%. Of course if you want the 4 out of 4 to score 0, then you'd need the separation to be 1 divided by ("Out of" -1), or 33.3% in your case, not 25%, and that would give 100%, 66.7%, 33.3%, and 0% for your four scores. Tell us which system you are using, and then you or we can work out a simple formula. -- David Biddulph "AL" wrote in message ... I have 3 columns **1 is best, 4 is worst Rank Out of Percentage 3 4 25% When I set up the original formula to divide 3/4 I get 75%, which is not what I am looking for. So I set another column to take the 75% and subtract 100% to get the 25%. Well, when I have this example: Rank Out of Percentage 1 5 100% It should be 100%, but the formula returns 80% (1/5=20% minus 100%=80%) I was trying to set an IF statement within my formula if my rank column had a 1, then my percentage column would read 100%. I'm having difficulty since there is already a formula in the cell. Thanks! "Don Guillett" wrote: Can you explain? -- Don Guillett Microsoft MVP Excel SalesAid Software "AL" wrote in message ... Can you use an IF statement with an already existing formula? Example: cell formula =d6/d7; can I then add an IF statements? Thanks, AL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|