Thread: How do I set a price minimum in a spreadsheet?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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
...



Reply With QuoteReply With Quote