Posted to microsoft.public.excel.worksheet.functions

Joanne Ramaekers

Posts: n/a

Array formula to give blank

I have an array formula that is working perfectly:
{=SUM(IF(Quote_Code=A3,Quote_Amt,))}

I would like to make one change, but I don't seem to be able to get it
working. When the locigal test is false I would like to dispaly nothing in
the cell. It's currently displaying 0.00.

I have tried {=SUM(IF(Quote_Code=A3,Quote_Amt," "))} but is still shows 0.00.

Any ideas?
Jo

P.S. I'm using Office 2003

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
Positioning Numeric Values Resulting from 6 Column Array Formula	Sam via OfficeKB.com	Excel Worksheet Functions	2	January 5th 06 02:03 AM
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it !	xlguy	Excel Discussion (Misc queries)	6	December 15th 05 06:24 PM
Array	Brad	Excel Worksheet Functions	9	October 17th 05 09:00 PM
Editing Array Formula	[email protected]	Excel Worksheet Functions	7	August 28th 05 06:46 AM
What instead of an array formula part 2	Reg Besseling	Excel Discussion (Misc queries)	2	December 10th 04 07:35 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us