| 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. |
| 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) | |||
Threaded Mode
