Calculation including two cells if both have data or one

[TheJay]

I need to create a spreadsheet to calculate the total of two or three cells depending on whether just two or all three contain data.

A3 contains an amount of money
B3 contains a number from 1-12
C3 contains another amount of money (if input)

The total in D3 will either be A3*B3 or A3*B3+C3

I'm not sure how to do this and make it work either way without errors or hidden cells.

Can someone please help?

Thanks.

 

[Fluff]

How about
=A3*sum(B3:C3)

 

[Eric W]

Why not just

=A3*B3+C3

If C3 is empty, it will add 0 to the total.

 

[TheJay]

Thank you so much for your replies. I can't believe that my original answer was correct, I assumed it wouldn't work but it did when I tested it as suggested.

 

[Eric W]

Glad we could help!