Where would I add iferror function to suppress DIV/0 error message?

[PWil84]

Hello All,

I recently wrote the formula below but I'm unsure about where to add the iferror function to suppress the DIV/0 error message. Can you please help?

=(INDEX(INDIRECT("'" & D1503 & "'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'" & D1503 & "'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'" & D1503 & "'!$3:$3"),0))/INDEX(INDIRECT("'TOTAL DC BUDGET'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'TOTAL DC BUDGET'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'TOTAL DC BUDGET'!$3:$3"),0)))*INDEX(INDIRECT("'DIGITAL BUDGET'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'DIGITAL BUDGET'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'DIGITAL BUDGET'!$8:$8"),0))

 

[Fluff]

How about

=IFERROR((INDEX(INDIRECT("'" & D1503 & "'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'" & D1503 & "'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'" & D1503 & "'!$3:$3"),0))/INDEX(INDIRECT("'TOTAL DC BUDGET'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'TOTAL DC BUDGET'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'TOTAL DC BUDGET'!$3:$3"),0)))*INDEX(INDIRECT("'DIGITAL BUDGET'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'DIGITAL BUDGET'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'DIGITAL BUDGET'!$8:$8"),0)),"")

 

[etaf]

probably at the front

=IFERROR (

your formula

, "" )

 

[PWil84]

How about

=IFERROR((INDEX(INDIRECT("'" & D1503 & "'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'" & D1503 & "'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'" & D1503 & "'!$3:$3"),0))/INDEX(INDIRECT("'TOTAL DC BUDGET'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'TOTAL DC BUDGET'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'TOTAL DC BUDGET'!$3:$3"),0)))*INDEX(INDIRECT("'DIGITAL BUDGET'!$A$1:$AA$500"),MATCH($A1503,INDIRECT("'DIGITAL BUDGET'!$C1:$C$500"),0),MATCH($B1503,INDIRECT("'DIGITAL BUDGET'!$8:$8"),0)),"")

I'm getting the too few arguments message

 

[Fluff]

Try copying it again, I added an extra couple of brackets.

 

[PWil84]

Try copying it again, I added an extra couple of brackets.

I did but one and the cells are coming back blank which is great but I'd like them to come back with zeroes formatted in currency and formatting seems to be a problem.

 

[Fluff]

If you want a zero then just change the "" to 0 at the end of the formula

 

[PWil84]

If you want a zero then just change the "" to 0 at the end of the formula

Thanks alot this worked

 

[Fluff]

Glad we could help & thanks for the feedback.