Adding IF function to existing (complex) Formula

Greetings

I would like to add an IF function to an existing fomula but I am having trouble with exactly where I can enter it, or even if this is the correct formula I should be using. The IF function I am trying to add is the:

IF blank return blank (instead of 0).

My existing formula is:

=IF(ROWS(A$12:A12)>Transactions!$G$2,"",INDEX(Transactions!A$8:A$13,SMALL(IF(Transactions!$A$8:$A$13>=Transactions!$E$2,IF(Transactions!$A$8:$A$13<=Transactions!$E$3,ROW(Transactions!$A$8:$A$13)-ROW(Transactions!$A$8)+1)),ROWS(A$12:A12))))

This is my 1st post and I am some what of a noobling with lengthy Formulas, so I will apologise in advance for any potential faux pas. I would go into a bit more detail on the above formula but I have a feeling that i could come accross as condescending.

Thanks in advance

Thanks Andy for the prompt resonse. I am copying this existing formula from cell A12 accross to cell M12 and down over a number or rows. Is there anywhere in particular that I should copy and paste the IF(A1<>"",A1,"")? I have tried entering at the beginning and at the end but to no avail.

I am extracting data from another sheet "Transactions" using the existing formula. It's the blanks on the Transactions sheet that I would like to return as blanks on the "expense claim Form" sheet. Do I need to reference the cells that are blank on the Transactions sheet, or the cells that end up blank on the Expense claim form sheet? Eg: IF cells on Transaction sheet are blank, return blank on Exp Claim Form. OR do I enter a formula that says if the return is blank (0) on the Exp Claim Form, enter blank?

Ok got it and it's looking good.

That's great stuff Andy, thanks for your help.