=MIN(A1:A100)
will return the minimum value in the range A1 to A100
--
Cheers
Nigel
"phahn" <[email protected]> wrote in message
news:[email protected]...
>
Here is another guess.
=if(calcuated price < minimum price, minimum price, calculated price)
or
=max(calculated price,minimum price)
--
Regards,
Tom Ogilvy
"phahn" <[email protected]> wrote in message
news:[email protected]...
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks