ExcelBanter - IF Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Formula (https://www.excelbanter.com/excel-discussion-misc-queries/163647-if-formula.html)

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

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

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

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

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

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 -

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

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