Posted to microsoft.public.excel.worksheet.functions

Daryl S

external usenet poster

Posts: 135

Large formula

I get negative values when appropriate. What does your data look like?
--
Daryl S

"BuckinB" wrote:

In Excel 2007
How do I get the formula: =large(a1:a9,6) to return negative numbers, I
only get positive.

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
Formula too large	Cindyt	Excel Discussion (Misc queries)	4	July 14th 09 07:31 PM
Large Formula Help	Canon	Excel Discussion (Misc queries)	1	April 24th 09 02:33 PM
simplify a large formula	Centauro	New Users to Excel	7	July 30th 08 03:11 AM
=large formula	[email protected]	Excel Discussion (Misc queries)	1	August 21st 06 08:54 PM
to large if formula	allertonagain	Excel Worksheet Functions	2	February 13th 06 10:14 AM

All times are GMT +1. The time now is 10:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us