Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#Value when entering a circular reference
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:) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular Reference | Excel Worksheet Functions | |||
Why is this a circular reference? | Excel Discussion (Misc queries) | |||
circular reference | Excel Discussion (Misc queries) | |||
circular reference when using a UDF | Excel Programming | |||
Circular reference | Excel Programming |