Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use circular references that are allowed in Lotus 123?
I try to write a formula that has a variable value in column F which is
compared to column H. Column H should always contain highest value of the two columns: If(F3H3, F3,H3). This works in Lotus 123 but not Excel 2003. Help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use circular references that are allowed in Lotus 123?
Put your formula in another column. Or, if you *insist* on using circular
reference, under Tools-Options - calculation, set calculation to manual with an iteration of 1. You could now use a circular reference, and press F9 to cycle through 1 calculation. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "DAVIDDON" wrote: I try to write a formula that has a variable value in column F which is compared to column H. Column H should always contain highest value of the two columns: If(F3H3, F3,H3). This works in Lotus 123 but not Excel 2003. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular References | Excel Worksheet Functions | |||
circular references | Excel Discussion (Misc queries) | |||
circular references | Excel Discussion (Misc queries) | |||
Those Circular References... | Excel Discussion (Misc queries) | |||
Help :Circular References | Excel Worksheet Functions |