Calculation including two cells if both have data or one

TheJay

Board Regular
Joined
Nov 12, 2014
Messages
141
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.
 
Last edited:

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,626
Office Version
365
Platform
Windows
How about
=A3*sum(B3:C3)
 

TheJay

Board Regular
Joined
Nov 12, 2014
Messages
141
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,022
Messages
5,466,093
Members
406,464
Latest member
buks1232000

This Week's Hot Topics

Top