Formula Help

[MarkAndrews]

Here's an extract from my sheet

Abort - Jan.xls
	I	J	K	L
1	Networkdays	Introducer		IntroducerID
2	NA	LegalMove		LegalMove
3	NA	LegalMove		FirstActive
4	NA	FirstActive		YourMove
5	6	FirstActive		NationalWestminsterHomeLoansLtd
6	NA	LegalMove		Halifax
7	NA	LegalMove		TheRoyalBankofScotlandplc
8	NA	LegalMove		BritanniaBuildingSociety
9	NA	LegalMove		IntelligentFinance
10	NA	#N/A		MortgageAdviceBureau
11	163	YourMove		Oneaccount
12	13	NationalWestminsterHomeLoansLtd		TheMayfairOffice
Data

Column I is an IF Formula - When i use find & replace (to replace the NA with blanks) the query i have running from this page, does not recognise the blanks, nor does the replace work as the formula still shows

Any ideas?

TIA

Mark

 

[Krishnakumar]

Does

=IF(ISNUMBER(E2),NETWORKDAYS(D2,E2),0)

this help you?

 

[Andrew Poulsom]

You can't use replace to change the result of a formula. You have to change the formula so that it returns the result you want.

 

[MarkAndrews]

You can't use replace to change the result of a formula. You have to change the formula so that it returns the result you want.

Andrew, thanks

A Query using MS Query uses this sheet, the query result must show the days (or true result of the formula)

Any idea's how to get around this?

TIA