Formula stopped working

[mtntgr]

Hi,

1st time ever, a formula pasted throughout a column stopped working.
#VALUE! "A value used in the formual is the wrong data type."
=IF(O25="","",((F25+G25+I25+O25)+R25+Q24))
works in preceding 20 cells...
checked all cell formatting, maybe I'm tired but can't find it....
Is it possible for a worksheet to get corrupted like this?

Any suggestions much appreciated.

Thanks,
Ken

 

[mtntgr]

I removed that text, and re-pasted original formulas...
But(!) that text was not in there before problem started???

MSFT is trying to drive me insane (and doing a good job).

 

[mtntgr]

Thanks for your help.

Although it turned out to be a "tempest in a teapot", on the bright-side:
1- I learned about the Colo software- nifty!
2- I met another helpful person at the Forum.

Regards,
Ken

 

[Richard Schollar]

Ken

I'm glad you got it working - and still while retaining some hair on your head I hope

Best regards

Richard