I need the max dimension object but want to exclude a value (“None”) from the calculation (and this value will not always be the maximum).
[list]Object values = A, B, C, None[/list]
so my formula is:
MyFormula = If (<Object> <> "None") Then Max(<Object>)
however this returns a #Computation error.
So I broke it into 2 variables:
Variable 1= If (<Object> <> "None") Then (<Object>)
[list]Variable 1 values = A, B, C, blank[/list]
Variable 2= max(<Object>)
This actually puts the formula text in the cell, .i.e. “max()” as character text so
[list]Variable 2 value = “max()”[/list]
What should I do? I’m using full client 6.1 a
Nile (BOB member since 2004-02-12)