if the current row is same as below row number?

[okl]

how do i perform a subtraction only if the current row's column A is same as the below column A number?

[Richard Buttrey]

Hi

In say B10
=If(A10=A11, (your subtraction),0)

HTH

[okl]

i tried to use A2="C" but it doesnt work ?

column A is text field with A, B or C.


=if(A2="C",(B2-B3),0)

the condition return false, even that A2 is = "C"

[olasa]

What does not work? Your question is a bit vague.
//Ola

[okl]

nevermind, it work now on my home pc, but not in office's

I figure out tomorrow again!