help with if function

[gunners_fan]

I am trying to write a formula to have a cell enter a zero if a cell it is calculating from has an error and if not sum two cells and multiply by something else. Tried using =IF(ISERR(D11),"0","=((D11+D12)*11.5)") but it just puts my formula in the cell and #value ! if not. This is for a timesheet calculating hours worked in column D and amount owed in column E. Have 10 days I want this done. Can someone help?

Thanks
Chris

[TABLE="width: 384"]
<colgroup><col width="132" style="width: 99pt; mso-width-source: userset; mso-width-alt: 4827;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;"> <tbody>[TR]
[TD="class: xl68, width: 132, bgcolor: transparent"]10[/TD]
[TD="class: xl68, width: 132, bgcolor: transparent"] a[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]b[/TD]
[TD="class: xl69, width: 80, bgcolor: transparent"]c[/TD]
[TD="class: xl66, width: 109, bgcolor: transparent"]d[/TD]
[TD="class: xl67, width: 101, bgcolor: transparent"]e[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]11[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]08/03/17[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]off[/TD]
[TD="class: xl69, bgcolor: transparent, align: right"]off[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]#value ![/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]12[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0.00[/TD]
[TD="class: xl67, bgcolor: transparent"] This is where I want the formula[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]13[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Welcome to the Board!

Try:

=IFERROR(([COLOR=#333333]D11+D12)*11.5,0)[/COLOR]

or

=IF(ISERR(D11),0,(D11+D12)*11.5)

Note anything you place between double-quotes is treated as literal text and will not be evluated.

 

[gunners_fan]

Thank you so much!! That works great!!

 

[Joe4]

You are welcome!