#Value when entering a circular reference

R

Rookie

I have a circular formula I am entering =IF('LC + CC'!B3="","",'LC +
CC'!B3)+('LC + CC'!B3*$F$69)+('Sales Price (2)'!B3*'Sales
Price'!$F$70)+('Sales Price (2)'!B3*'Sales Price'!$F$71)+('Sales Price
(2)'!B3*'Land Cost'!B$14) that relies on data to be built from the following
formula =IF('Sales Price'!B3="","",'Sales Price'!B3/'Sales Price'!$F$75). I
keep getting #VALUE!. If I enter the formulas step by step they work. However
when I fill down rows and across columns they give me the error.

Please advise if there is a way to make this work:)
 

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

Copying a formula with multiple worksheets down rows and across co 1
Index and match formulas 1
Which formula will return a value for this table? 1
I need to use a countif but looking a cell value 5
#VALUE! error 1
Cell reference formula problem 5
Sale options on a CSV 1
circular reference 2

Top