My company has always used Lotus 1-2-3 for spreadsheets in the past. I
am now the financial person and I have vowed to change all my files to
Excel. I have an IF formula that translates to #VALUE, when I am
asking it for ------, as the result to an IF statment in the previous
column that answers a ------ value. Can anyone help me? What info do
I need to post? Or would it be easier if I emailed the file?

Thanks for any help you can give me.

Cheri