How can I use circular references that are allowed in Lotus 123?

D

DAVIDDON

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(F3>H3, F3,H3). This works in Lotus 123 but not Excel 2003.
Help!
 
L

Luke M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lotus 123 @nsum function equivalent in excel(?) 10
In Excel what can I use for the XINDEX function from Lotus 123? 2
How to make a Let statement in Excel? 2
Can I have two conditions in a SUMIF? 5
Bit of a complex SUM 4
Can't get a formula to work in each row of an Excel sheet. 2
SUMPRODUCT with criteria including OR function 4
how do I use array references in VLOOKUP()? 2

Top