circular reference error for simple IF statement

's Computer Specifications

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.

's Computer Specifications

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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk

"aileen" <(E-Mail Removed)> wrote in message
news:A4B13B9F-5D19-40A9-A2C8-(E-Mail Removed)...
> 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.
>
>
>

's Computer Specifications

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.
>
>

's Computer Specifications

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
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "aileen" <(E-Mail Removed)> wrote in message
> news:A4B13B9F-5D19-40A9-A2C8-(E-Mail Removed)...
> > 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.
> >
> >
> >
>
>
>

's Computer Specifications

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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk

"aileen" <(E-Mail Removed)> wrote in message
news:1911E4F2-C80A-4252-809F-(E-Mail Removed)...
> 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
>>
>> (E-Mail Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "aileen" <(E-Mail Removed)> wrote in message
>> news:A4B13B9F-5D19-40A9-A2C8-(E-Mail Removed)...
>> > 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.
>> >
>> >
>> >
>>
>>
>>
>

's Computer Specifications

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
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "aileen" <(E-Mail Removed)> wrote in message
> news:1911E4F2-C80A-4252-809F-(E-Mail Removed)...
> > 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
> >>
> >> (E-Mail Removed)
> >> Replace @mailinator.com with @tiscali.co.uk
> >>
> >>
> >> "aileen" <(E-Mail Removed)> wrote in message
> >> news:A4B13B9F-5D19-40A9-A2C8-(E-Mail Removed)...
> >> > 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.
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >
>
>
>

's Computer Specifications

You're very welcome. Thanks for posting back.

--

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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk

"aileen" <(E-Mail Removed)> wrote in message
news:9240A787-8A2B-4F14-8017-(E-Mail Removed)...
> 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
>>
>> (E-Mail Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "aileen" <(E-Mail Removed)> wrote in message
>> news:1911E4F2-C80A-4252-809F-(E-Mail Removed)...
>> > 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
>> >>
>> >> (E-Mail Removed)
>> >> Replace @mailinator.com with @tiscali.co.uk
>> >>
>> >>
>> >> "aileen" <(E-Mail Removed)> wrote in message
>> >> news:A4B13B9F-5D19-40A9-A2C8-(E-Mail Removed)...
>> >> > 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.
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >
>>
>>
>>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Its always the simple ones....Basic Circular Reference Problem.	=?Utf-8?B?RGF2ZSBMb21heA==?=	Microsoft Excel Worksheet Functions	5	6th Jul 2006 03:12 PM
Simple Circular Reference Problem	Gary	Microsoft Excel Worksheet Functions	2	12th May 2006 01:21 AM
If statement to avoid Creating Circular Reference	=?Utf-8?B?VGltIEg=?=	Microsoft Excel Worksheet Functions	3	22nd Dec 2005 05:37 AM
How do I fix a circular reference in a financial statement?	=?Utf-8?B?ZHJqYXloYXdrMjU=?=	Microsoft Excel Misc	0	7th Feb 2005 05:19 PM
Circular reference error	Linda	Microsoft Excel New Users	3	27th Apr 2004 04:09 AM