If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formula yeilds non-number result
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. |
Thread Tools | |
Display Modes | |
|
|