Thread: Help on a formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
  
Posts: 78
Default Help on a formula
If a price is 0, then transform it into a large price, something like (A1=0)
*999+A1. So the formula can be:
=$D1 * MIN(($A1=0)*999+$A1,($B1=0)*999+$B1,($C1=0)*999+$C 1)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1

Reply With QuoteReply With Quote