If, AND, OR - How to

[fernipascual]

Hi:

I have two columns with data going down hundreds of rows, including blank cells. Columns E & F.

If in the row, both E and F > 0, $10. If one of them is 0 (or blank) and the other >0, then $5, If both are 0 (or blank), then $0.

I hope this is enough information.

Thanks

 

[Jonmo1]

Try

=COUNTIF(E2:F2,">0")*5

 

[fernipascual]

I ommitted the most important part because I thought I could figure it out. So here’s the rest.

This is a program that pays based on product sold. There are two products, A & B and two eligible periods, Month 1 and Month 2. They only get paid once for each product. Either $5 per product or $3. Here are the scenarios:

Month 1 - Sold product A & B = $10. Month 2 – sold product but no payment
Month 1 – Sold product A = $5, no B. Month 2 - Sold product B = $3, (doesn’t matter if sold A)
Month 1 – Sold product B = $5, no A. Month 2 - Sold product A = $3, (doesn’t matter if sold B)
Month 1 – no product sold. Month 2 sold A & B = $6
Month 1 – no product sold. Month 2 sold A = $3, no B = $0
Month 1 – no product sold. Month 2 sold B = $3, no A = $0
Month 1 and Month 2 - Did not sell product at all

Thanks!

E	F	G	H	I
Month 1	Month 1	Month 2	Month 2	Payment Formula
Prod A	Prod B	Prod A	Prod B
4	2	5	8	$10
5	0	5	2	$8
0	5	2	2	$8
0	0	3	5	$6
0	0	3	0	$3
0	0	0	2	$3
0	0	0	0	$0
				0

<tbody>
</tbody>

 

[fernipascual]

Hello folks:

I am reviving this thread since it seems to have fallen through the cracks.

Thanks