Posted to microsoft.public.excel.misc

Excel 2007 - SPB Excel 2007 - SPB is offline

external usenet poster

Posts: 9

Array formula & #N/A

I have the array formula below which gives me a result when there is data but
when the data is missing, which is what I am checking for I get "#N/A" I
would like it to be a blank cell, ("") I have tried using "=if(isna( " and
combination, but get a too many arguments for this function error

{=index(Lpilot,match(1,(text(ldate,"ddmmyy")=text( #a136,"ddmmyy"))*(B$129=Ltype),0))}

any ideas / help

SPB

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
array formula	HeatherTaxONA	Excel Discussion (Misc queries)	1	June 27th 07 07:42 PM
meaning of : IF(Switch; Average(array A, array B); array A)	DXAT	Excel Worksheet Functions	1	October 24th 06 06:11 PM
Array Formula	Brendan Vassallo	Excel Discussion (Misc queries)	4	September 13th 06 02:25 AM
Array Formula Help	rmeister	Excel Discussion (Misc queries)	2	April 2nd 06 04:08 AM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM

All times are GMT +1. The time now is 02:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us