How do I set a price minimum in a spreadsheet?

=MIN(A1:A100)

will return the minimum value in the range A1 to A100

--
Cheers
Nigel



"phahn" <phahn@discussions.microsoft.com> wrote in message
news:E86BAF7E-8894-4ADB-B93E-C931AD52F987@microsoft.com...
>

Here is another guess.

=if(calcuated price < minimum price, minimum price, calculated price)

or

=max(calculated price,minimum price)

--
Regards,
Tom Ogilvy

"phahn" <phahn@discussions.microsoft.com> wrote in message
news:E86BAF7E-8894-4ADB-B93E-C931AD52F987@microsoft.com...
>