Circular Reference is sending me in CIRCLES

G

Guest

Can anyone tell me why I keep getting a circular reference
message on the formula below, or do I need to provide more
info? The formula is set in cell J123, and in cell C18 I
have =J123.

=IF(AND(H94-I94-G118>G94<=H122<=C17,C39<B39),H94-I94-
G118,0)
 
F

Frank Kabel

Hi
is any other the other cells used in your formula
referencing cell J123 or C18?
 
G

Guest

Hi Frank

I'm not sure, I'm a fish out of water, when I choose
circular reference from the tool bar, it gave me all of
the following :(

$C$19
$C$18
$J$123
$C$39
$C$32
$C$29
 
G

Guest

I'm confused, Post the formulas in the other cells???
Sorry, but I'm very new at this.
 

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

Top