parameter limits

[bitman]

I would have liked to restrict a variables range of values by reference to another variable, for example Total People = 5, so Ladies cannot be > 5, can this be done?

[bitman]

I guess what I'm asking is can the min and max fields use a calculation?

[mgkennard]

Hello,

You would need to use the if function.

So for example,

if(ladies < total people, ladies, total people)

This says if ladies is smaller than total people then use ladies, otherwise use the maximum value which is total people.

If this is not what you require please let me know!

Matthew
Apps On The Move

[mgkennard]

... or ...

min(ladies, total people)

which would be simpler!

[bitman]

That'll do me, thanks, I was hoping for data-entry validation, but I know that would be a lot to ask, the min & max values would have to accept calcs. Don't want much do I?

Many thanks, great product.