Max function

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 :us: (BOB member since 2004-02-12)

How about

Variable1
= If ( = “None”) Then null Else ()

Then create Variable 2
=max()

Variable 2 value = “max()”
This happens when you are missing the = in a formula it take it as a constant instead of a formula


Michele Pinti (BOB member since 2002-06-17)

Opps :oops:
Yeah that took care of it (didn’t need to turn it to null, just need to put in the “=” :oops:
Thank you Michele

…and when I put the max in front instead of the end, I could do it in one shot.


Nile :us: (BOB member since 2004-02-12)