Tally has attended:
Excel VBA Intro Intermediate course
Formula - explained
OK maybe a dumb question.... i need to interpret the below formula as i dont think it is doing what it should:
=IF((AND($C4="Y",$D4="Y")),$I$34*$K4,IF(AND($C4="Y",$D4="n"),($I$34*K4),$K4))
My interpretation is :
If C4 and D4 = y, then the cell K4 should = I34*K4
If C4 = Y and D4 = N, then cell k4 should = I34*K4
Is my interpretation correct, the last K4 is the cell to put the answer in?
Thanks
Tally
RE: formula - explained
Hi Tally
Which cell is the formula in in your spreadsheet?
thanks
Amanda
RE: formula - explained
Hi Amanda
Its K4... its a spreadsheet i am picking up from some one else...
Thanks
Tally
RE: formula - explained
Hi Tally
I think that you will find that the formula will throw up a circular reference if the formula is in K4 and it is also referring to that cell.
Say for example if you have the formula in cell K5, this is what would happen:
If C4 and D4 = y, then the cell K5 should =I34*K4
If C4 = Y and D4 = N, then cell K5 should = I34*K4
Otherwise (in any other situation apart from those described above) enter what is in cell K4 into cell K5
I hope this helps.
Amanda
