IF AND - need help with formula
Hi Kelly, maybe this -
=IF(AND(A2=0,B2=0),"",IF(B20,SUMPRODUCT(B2,C2),IF (AND(A20,B2=0),SUMPRODUCT(A2,C2),"")))
Assumes your Sub1, Sub2 and Rate1 are columns A,B and C respectively
and that your first line of data is on Row 2.
Put that formula in D2(or wherever) and copy it down.
Regards,
Muppet Man.
On Sep 25, 7:37*pm, lsgKelly
wrote:
I have to write a formula that accomplishes the following task:
I have a spreadsheet that has three columns. *The columns are "Subs1"
"Subs2" and "RATE1". Here's what I want it to do:
If Subs1 = 0 and Subs2 = 0, ""
If Subs2 0, sumproduct (subs2,rates1)
If Subs1 0 and Subs2 = 0, sumproduct(subs1,rates1)
I know this isn't all that difficult, but for some reason, it is not working
for me.
Thanks in advance!
Kelly
|