|
how do i calculate minumum but 0 (zero) must not show as the min
|
how do i calculate minumum but 0 (zero) must not show as the min
=IF(MIN(rng)=0,"",MIN(rng))
-- __________________________________ HTH Bob "minimum" wrote in message ... |
| All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com