=INDEX(B2,MATCH(TRUE,E2,0)) - How to make FALSE show a 0.00 instead of #N/A?

[Mikey556]

Hello!

=INDEX(B2,MATCH(TRUE,F2,0))

The above formula matches information from B2 when I tick a checkbox. When I uncheck the box (false) it shows a #N/A error instead of a zero, which messes with a 'Totals' formula.

What is the best way to make FALSE show a 0.00 instead of #N/A?

Thankfully,

 

[Fluff]

How about

=IF(F2,B2,0)

 

[Mikey556]

How about

=IF(F2,B2,0)

Absolutely nailed it, and with a much simpler, elegant formula. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.