Posted to microsoft.public.excel.misc

kinsey

external usenet poster

Posts: 23

minimum function but want to exclude zero

I have a quotation form I use which has several supplier values in a column.
I want to calculate the minimum value but because every supplier does not
always
give a quote their value will show zero. In short I want the minimum in the
column
but excluding zero. How do I express this?

--
kinsey

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using min function without calculating 0 as minimum	chusu	New Users to Excel	2	October 4th 07 05:32 AM
How do I set a minimum value to be returned from IF function	KW	Excel Discussion (Misc queries)	1	June 27th 07 04:14 PM
Minimum function	bikemrh	Excel Discussion (Misc queries)	5	March 9th 07 08:25 PM
minimum function	cutyfurby	Excel Worksheet Functions	3	March 11th 06 06:47 PM
Can I retrieve a value and its format using the minimum function?	daled	Excel Worksheet Functions	1	November 2nd 05 09:38 PM

All times are GMT +1. The time now is 02:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us