WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a simple addition formula, but its precedents have if and lookup
formulas. the precedents change values correctly but the simple addition
formulas do not. If I copy, "paste special" on the precedent cells the
addition cells correct and stay that way when I undo the paste.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My formula cell has stopped adding the preceding cells. 1
tracing precedents 1
Converting Text to Number 3
Clever formula required (to find the word directly preceding mychosen word) 3
How do I reference a cell to another in the preceding worksheet 8
EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE 2
How to show all precedent arrows on whole worksheet at same time? 1
Excel Spreadsheet Trace Precedent Bars not showing up 1

Back
Top