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