Posted to microsoft.public.excel.worksheet.functions

stevew

external usenet poster

Posts: 3

Formula addition causes random #REF!

I have added a new formula to ledger worksheets and now the #REF! appears in
areas in the workbook. In order to fix it, all I have to do is copy a good
cell with the formula (one that isn't showing #REF!) to on that is showing
#REF! and all the cells in the workbook clear up. Any suggestions please?
Thank you
--
stevew

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Addition to Formula	lightbulb	Excel Discussion (Misc queries)	1	June 10th 09 02:16 AM
Sorting random Data created from a random formula	Six Sigma Blackbelt	Excel Discussion (Misc queries)	1	September 11th 08 11:03 PM
Addition Formula	LyndaP	Excel Discussion (Misc queries)	4	August 27th 08 08:42 PM
Formula for addition	tigermoth	Excel Worksheet Functions	3	February 27th 08 12:01 PM
help with simple addition formula	Juco	Excel Worksheet Functions	1	January 29th 05 12:51 PM

All times are GMT +1. The time now is 06:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us