How to find MIN or MAX of two variables?

[dmohanty]

Hi All,

Lets say I have two variables - VarA and VarB. .

How can I get a MIN and MAX between those two and store it in a 3rd variable called VarC?

Regards!

[swuehl · Accepted solution]

You can use RangeMax()  / RangeMin() functions, like

=RangeMax(VarA, VarB)

=RangeMin(VarA, VarB)