| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Circular Reference Error Even Though There Is No C.R. | Excel Worksheet Functions | |||
| Its always the simple ones....Basic Circular Reference Problem. | Excel Worksheet Functions | |||
| Simple Circular Reference Problem | Excel Worksheet Functions | |||
| If statement to avoid Creating Circular Reference | Excel Worksheet Functions | |||
| How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Hybrid Mode
