Posted to microsoft.public.excel.worksheet.functions

srpavar

external usenet poster

Posts: 11

Calculating Max & Min in a negative numbes

i Have a worksheet with these number, when i select maximum from this list
below it give -40.34, i want to -55.25 as maximum and the same for Minimum,
how to get with the formula, can anyone pl help.
-48.94
-53.39
-54.54
-55.25
-49.52
-40.34
Max -40.34
Min -55.25

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
Calculating growth with negative numbers	Tsipi4me	Excel Worksheet Functions	3	April 3rd 23 12:12 PM
Calculating and posting when a qty will go negative.	Gene Haines	Excel Worksheet Functions	0	November 5th 07 05:54 PM
How do you use the < funjctions when calculating negative numbe	woods-one	Excel Worksheet Functions	5	November 11th 05 07:15 PM
calculating positive and negative formulas	cliford	Excel Worksheet Functions	2	September 3rd 05 10:47 PM
Calculating negative time.	Brian	Excel Discussion (Misc queries)	4	April 7th 05 08:37 PM

All times are GMT +1. The time now is 07:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us