circular reference error for simple IF statement
 

This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True statement
is in the same field for both IF statements? Or is it something else in this
statement that's causing the error. Thanks for any help.

circular reference error for simple IF statement
 

You should be getting a "Too many arguments" message. If are getting a
circular reference then you must have the formula in one of the referenced
cells.

=IF(F1="C",A1,IF(B1="CALL",A1,0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True statement
is in the same field for both IF statements? Or is it something else in
this
statement that's causing the error. Thanks for any help.

circular reference error for simple IF statement
 

I'm guessing you have this in either F1, A1 or B1. Alternatively, a formula
in any of those cells ultimately refers to the cell that this formula is in.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"aileen" wrote:

This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True statement
is in the same field for both IF statements? Or is it something else in this
statement that's causing the error. Thanks for any help.

circular reference error for simple IF statement
 

Yes, I'm getting a "Too many arguments" message. Sorry, I put the wrong
error. Is there any way around this issue?

"Sandy Mann" wrote:

You should be getting a "Too many arguments" message. If are getting a
circular reference then you must have the formula in one of the referenced
cells.

=IF(F1="C",A1,IF(B1="CALL",A1,0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True statement
is in the same field for both IF statements? Or is it something else in
this
statement that's causing the error. Thanks for any help.

circular reference error for simple IF statement
 

The change to your formula that I gave in my last post will work or you can
use:

=IF(OR(F1="C",B1="CALL"),A1,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
Yes, I'm getting a "Too many arguments" message. Sorry, I put the wrong
error. Is there any way around this issue?

"Sandy Mann" wrote:

You should be getting a "Too many arguments" message. If are getting a
circular reference then you must have the formula in one of the
referenced
cells.

=IF(F1="C",A1,IF(B1="CALL",A1,0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True
statement
is in the same field for both IF statements? Or is it something else in
this
statement that's causing the error. Thanks for any help.

circular reference error for simple IF statement
 

Perfect. Thanks so much.

"Sandy Mann" wrote:

The change to your formula that I gave in my last post will work or you can
use:

=IF(OR(F1="C",B1="CALL"),A1,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
Yes, I'm getting a "Too many arguments" message. Sorry, I put the wrong
error. Is there any way around this issue?

"Sandy Mann" wrote:

You should be getting a "Too many arguments" message. If are getting a
circular reference then you must have the formula in one of the
referenced
cells.

=IF(F1="C",A1,IF(B1="CALL",A1,0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True
statement
is in the same field for both IF statements? Or is it something else in
this
statement that's causing the error. Thanks for any help.

circular reference error for simple IF statement
 

You're very welcome. Thanks for posting back.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
Perfect. Thanks so much.

"Sandy Mann" wrote:

The change to your formula that I gave in my last post will work or you
can
use:

=IF(OR(F1="C",B1="CALL"),A1,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
Yes, I'm getting a "Too many arguments" message. Sorry, I put the
wrong
error. Is there any way around this issue?

"Sandy Mann" wrote:

You should be getting a "Too many arguments" message. If are getting
a
circular reference then you must have the formula in one of the
referenced
cells.

=IF(F1="C",A1,IF(B1="CALL",A1,0))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True
statement
is in the same field for both IF statements? Or is it something else
in
this
statement that's causing the error. Thanks for any help.