I think I need a sumif formula.....??

[SM mechanic]

I need a formula where I can input numbers into 3 cells. and have the formula multiply the first cell by the second cell and add the third cell. With the variable in the second cell being if that number is equal to or less than 80 the first number gets multiplied by 1, and if it is greater than 80 it is multiplied by 1.1. for example
A1 1500
A2 78
A3 1000

sum would be 2500

A1 1500
A2 81
A3 1000

Sum would be 2650

I hope this makes sense.

Thank you for any help with this

 

[etaf]

=if(A2<=80,((A1*1)+A3),((A1*1.1)+A3))

Book4
	A	B	C	D
1	1500
2	78
3	1000
4
5	sum would be 2500			2500
6
7	1500
8	81
9	1000
10
11	Sum would be 2650			2650
Sheet1

Cell Formulas
Range	Formula
D5,D11	D5	=IF(A2<=80,((A1*1)+A3),((A1*1.1)+A3))

 

[iggydarsa]

=(A1*IF(A2>80, 1.1, 1))+A3

 

[SM mechanic]

Works perfectly!! thank you very much

 

[etaf]

you are welcome

 

[SM mechanic]

Both formula work perfectly, thank you to both of you for offering options.