Discussions
»
Special Interest Groups
»
Basic Coding Techniques
»
Finding the minimum or maximum of three variables
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 5/28/2005(UTC)
Posts: 4
Location: Australia
|
Hi Can some one help me please? I am trying to find the minimum and maximum of three variables
I am aware of the max and min functions but these only return the minimum or maximum of two variables, ie MAX(data1, data2) returns the max of data1 or data 2. How would findthe max of three??
hoping some one can give me a quick answer
thanks
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346
|
hey dovetree...... try something like , Max((Max(data1 ,data2 )),data3), ......h
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 5/28/2005(UTC)
Posts: 4
Location: Australia
|
thanks hayseed, I thought of nesting the function but was not sure. Tried it and it works!
thanks again
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Special Interest Groups
»
Basic Coding Techniques
»
Finding the minimum or maximum of three variables
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
