| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to avoid Creating Circular Reference
Good Day,
I have two columns of data With the following in each, in Cell L2 and filled down is =IF(H2=10,IF(U2=1,"$",1),IF(L3=1,IF(U2=1,"$",IF(W2 =1,"Trl",1)),0)) In cell M2 and filled down is =IF(I2=-10,IF(V2=1,"$",1),IF(M3=1,IF(V2=1,"$",IF(X2=1,"Trl ",1)),0)) This works - but what I need to be able to do is find a way to add: While the cell in one column has a value of 1, then the other cannot return a 1 until the value changes in the first changes Any Ideas? Best Regards, Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I avoid circular reference AND extra input | New Users to Excel | |||
| Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
| Need to avoid a circular reference... | Excel Worksheet Functions | |||
| Help solve a Circular Reference | Excel Worksheet Functions | |||
| How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Threaded Mode
