| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Threaded Mode
