IFERROR with nested formula

[K3MP0]

I love excel and use it every day, however today I am stumped I want to add IFERROR to this formula

=F3/SUM(B3:C3)

I have tried

=IFERROR(IF(=F3/SUM(B3:C3)),0)

and it is not working

Any help or guidance is appreciated.

Thank you

 

[K3MP0]

I can't find a way to edit my post? so wanted to fix the mistake of the formula that I have tried to remove the =before the F3

=IFERROR(IF(F3/SUM(B3:C3)),0)

 

[Fluff]

Hi & welcome to MrExcel
Try
=IFERROR(F3/SUM(B3:C3),0)

 

[K3MP0]

Hi & welcome to MrExcel
Try
=IFERROR(F3/SUM(B3:C3),0)

Thank you! I had too many parentheses and added an extra IF that was not needed.

I am looking forward to diving into this forum and finding the great truffles of knowledge that I am sure it contains.

 

[Fluff]

Glad to help & thanks for the feedback