"multiply" IF

[stan1986]

I have two columns (A & B). Column A are forecasted prices and Column B are the actuals. In column C, I am summing the products of either column multiplied by one cell, which is the "unit count". I am summing all of column C to total the most approximate budget.

PROBLEM: I want each cell in column C to contain a formula that will multiple the "unit count" (one cell) by column B IF there is a number > 0 there. IF there is not, I want it to multiply the "unit count" (one cell) by column A.

Unit Count: 2

A B C
1 0 ????
3 5 ????
4 5 ????
5 6 ????
5 0 ????

I want a formula in column C that makes the ????'s 2,10,10,12,10 respectively. Column C would then total 44.

PLEASE HELP!

 

[Jubjab]

Työkirja5
	A	B	C	D
1	Unitcount	2
2
3	1	0	2
4	3	5	10
5	4	5	10
6	5	6	12
7	5	0	10
Taul1

 

[Jubjab]

PS. Welcome to the board!

 

[lenze]

Hi and welcome to the board!!!

=IF(B2,B2*2,A2*2)

Hint: If UC will vary, name a cell for it(Say UC) or maybe even a Named Formula(Insert>Name>Define, refers to =2). Now your formula would be

=IF(B2,B2*UC,A2*UC)

Either a named range or formula can be easily changed
lenze

 

[stanleydgromjr]

stan1986,

Cell B1 is range name "UnitCount".

Excel Workbook
	A	B	C
1	Unit Count	2
2
3	1	0	2
4	3	5	10
5	4	5	10
6	5	6	12
7	5	0	10
8			44
Sheet1

The formula in cell C3 (copied down to C7):
=IF(B3=0,UnitCount*A3,UnitCount*B3)


Have a great day,
Stan

 

[stan1986]

Thank you so much to everyone who responded. This is a great community that I'm now thrilled to be a part of. Not only did I get my question answered but I've gotten variations that have helped me expand my excel knowledge. Best of all, everyone seems really sweet. THANKS for the help and warm welcomes!