Sorry, here they are.
=SUM(H15+J15) This one gives ###-- Cell H15 has =E9 in it.
=SUM(U8+X8+AA8+AD8+AG8) This one gives #VALUE!-- Cell X8 has =E10 in
it.
=IF(Z3="Fine","8",IF(Z3="Gargantuan","-4",IF(Z3="Huge","-2",IF(Z3="Large","-1",IF(Z3="Medium","0",IF(Z3="Small","1",IF(Z3="Tin y","2",IF(Z3="Diminutive","4"))))))))
This one gives FALSE-- Cell Z3 requires one of those 8 words to be
placed in it for this formula to "work".
Almost all of my formulas require a number to be placed in Cells C8
thru C13. Once a number is placed in one of those cells, they all spit
out what I need, no errors.
Thanks again.
Alan
--
AnimatorElf
------------------------------------------------------------------------
AnimatorElf's Profile:
http://www.excelforum.com/member.php...o&userid=32944
View this thread:
http://www.excelforum.com/showthread...hreadid=527813