IF AND - need help with formula
If a merged cell is the answer, you have asked yourself the wrong question.
:-(
--
David Biddulph
"lsgKelly" wrote in message
...
Unfortunately, in this case, I have no choice.
"MuppetMan" wrote:
Save yourself a world of headaches and dont use Merged Cells, ever!
Take Care
Muppet Man
On Sep 25, 8:37 pm, lsgKelly
wrote:
Now I get a number, but it's wrong. Is there a problem with using
SumProduct
in Merged cells? The I41:I45 are two cells merged together.
Thanks
"muddan madhu" wrote:
small change
=IF(AND(B41=0,J33=0),"",IF(AND(J330,B410),SUMPRO DUCT(J33:J37,I41:I45)*12,**
SUMPRODUCT(B41:B45,C41:C45)*12))
SUMPRODUCT(J33:J37,I41:J45) change to SUMPRODUCT(J33:J37,I41:I45)
On Sep 25, 3:01 pm, lsgKelly
wrote:
Here's what I have, but it's returning a #Value error. It might
help you
understand what I'm trying to do.
=IF(AND(B41=0,J33=0),"",IF(AND(J330,B410),SUMPRO DUCT(J33:J37,I41:J45)*12,**SUMPRODUCT(B41:B45,C41: F45)*12))
I have two cells, B41 and J33. If B41=0, then I want it to return
a blank
cell. If J33 is greater than 0, then I want it to do this part of
the
function: SUMPRODUCT(J33:J37,I41:J45)*12
If J33=0 but B410, then I want it to return this part of the
function:
SUMPRODUCT(B41:B45,C41:F45)*12
Hope that helps. :)
"Mike H" wrote:
Kelly,
I might be being a bit slow but I don't understand the question.
Can we see
a couple of sample lines of data and the answer(s) you expect to
get from
that data?
Mike
"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- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
|