Forum Discussion
Formulas not working sometimes
I am an amateur when it comes to Excel but knew enough a few years ago to set up a spreadsheet with multiple tabs to keep track of a collection (currently over 11,000 pieces). This was probably in ab...
Minizv When you say "does not work", do you get an error, zero or the a number that doesn't seem to be correct?
Just a few tests regarding your example =SUM(C7,F7), what do you get when you just type =C7+F7 ?
And how about:
=ISNUMBER(C7)
and
=ISNUMBER(F7)
Thanks for the reply.
ISNUMBERS both return TRUE
=C7+F7 Nothing. Only the formula in the cell. I think I am right in saying that this is how it originally was.
Minizv Odd! Can you share the file via Onedrive?
- Yes I could do and there is nothing confidencial in it. I have never done it before though. Can I do it in such a way that only you see it?
