Gives zero instead of blank on using formula

[Etax]

Below formula is the effort contributed by HansDouwe

Please Login or Register  to view this content.

What is I want to know is that, when above formula is used wherever,there is blank cell in source workbook here in formula referred as 'Template' worksheet ,it gives me zero instead of blank ?

Can this be modified slightly to avoid getting zero thru formula itself.

[AliGW]

Try this:

Please Login or Register  to view this content.

If this doesn't work, attach the workbook.

[AliGW]

You are opening too many new threads - follow-up questions on formulae provided should be made within the original thread.

I have closed this thread and copied the posts across to the original thread here: https://www.excelforum.com/excel-for...data-type.html

If you continue to open threads unnecessarily, you could find yourself banned from these forums, so please think carefully in future.