How do I set a price minimum in a spreadsheet?
 

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" wrote in message
...

How do I set a price minimum in a spreadsheet?
 

Here is another guess.

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

or

=max(calculated price,minimum price)

--
Regards,
Tom Ogilvy

"phahn" wrote in message
...