Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Error using MAX fnc
A B C D
Cur Prchs Prev Cur Prc Prc Max Max ==== ==== ==== ==== 10 8 11 11 12 13 13 13 15 12 13 15 Col A, Current Price, changes daily Col B, Purchase price is constant Col C, Previous Max from yesterday Col D, Current Max = MAX(A,B,C) If C is less than D, then Copy D to C Using Excel functions, this results in a circular error The solution is a piece of cake in Fortran (remember that?), but my VBA isn't up to it. Help!!! - bud - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular Error | Excel Worksheet Functions | |||
circular error | New Users to Excel | |||
Circular Refernce error | Excel Discussion (Misc queries) | |||
Circular Reference error... | Excel Discussion (Misc queries) | |||
Turning off Circular Error Help | Excel Discussion (Misc queries) |