=IF(O3=1,"7",IF(O3=2,"6",IF(O3=3,"5",IF(O3=4,"4",I F(O3=5,"3",IF(O3=6,"2",IF(O3=7,"1")))))))

Remove double quotes around the numbers.

Or you can try this elegant solution.

=8-O3


"RichM" wrote:

=IF(O3=1,"7",IF(O3=2,"6",IF(O3=3,"5",IF(O3=4,"4",I F(O3=5,"3",IF(O3=6,"2",IF(O3=7,"1")))))))

This works and I have a column of them but when I try to average the column
it doesn't work.

Thank you


"Lars-Ã…ke Aspelin" wrote:

On Sat, 29 May 2010 10:52:01 -0700, RichM
wrote:

Hello,

I made conditional formulas but with the numbers that result I am unable to
calculate their average. I get the #DIV/0! error. They are formatted as
"General" but even when I format them as numbers they cannot be averaged. I
have to copy them and "paste special" them as values, then there is an error
message that pops up (the little green triangle in the upper left of the cell
that I click on) where I can convert them to numbers.

Is there a way to make them numbers when they are the result of conditional
formulas without going through all those steps?

Thank you.

Post an example of your "conditional formula".

Lars-Ã…ke
.