J2
K2 L2
RESERVES (LAST QTR) RESERVES (THIS QTR) CHANGES
$1,000.00


I nedd to know the formula to show the change between J2 and K2 in L2
if K2 is populated. I cant seem to get it to work? Can anyone help??
Thanks!

To answer your question use this in L2

=IF(K2="","",J2-K2)


But, how about if J2 is not populated and K2 is populated?


Gord


On Thu, 5 Jan 2012 15:04:08 -0800 (PST), Michelle
wrote:

J2
K2 L2
RESERVES (LAST QTR) RESERVES (THIS QTR) CHANGES
$1,000.00


I nedd to know the formula to show the change between J2 and K2 in L2
if K2 is populated. I cant seem to get it to work? Can anyone help??
Thanks!

On Jan 5, 5:19*pm, Gord Dibben wrote:
To answer your question use this in L2

=IF(K2="","",J2-K2)

But, how about if J2 is not populated and K2 is populated?

Gord

On Thu, 5 Jan 2012 15:04:08 -0800 (PST), Michelle



wrote:
J2
K2 * * * * * * * * * * * * * * * * * * * L2
RESERVES (LAST QTR) RESERVES (THIS QTR) * * CHANGES
$1,000.00

I nedd to know the formula to show the change between J2 and K2 in L2
if K2 is populated. I cant seem to get it to work? Can anyone help??
Thanks!- Hide quoted text -

- Show quoted text -

thanks for the help - Im awful at excel! It will always be populated -
if there is a claim, we have to set a reserve by SEC rules. This is so
helpful! Thank you!

On Jan 5, 5:19*pm, Gord Dibben wrote:
To answer your question use this in L2

=IF(K2="","",J2-K2)

But, how about if J2 is not populated and K2 is populated?

Gord

On Thu, 5 Jan 2012 15:04:08 -0800 (PST), Michelle



wrote:
J2
K2 * * * * * * * * * * * * * * * * * * * L2
RESERVES (LAST QTR) RESERVES (THIS QTR) * * CHANGES
$1,000.00

I nedd to know the formula to show the change between J2 and K2 in L2
if K2 is populated. I cant seem to get it to work? Can anyone help??
Thanks!- Hide quoted text -

- Show quoted text -

I have another question: How do I get a sum total of cells if the
cells meet certain criteria? meaning, ony add the reserve to the total
if the status is Open - Active and the Nature of Case is NOT
Government Investigations?

F H J
STATUS NAT OF CAST RESERVE

Open - Active EEOC 1000

Open - Active Gvt Invest 2000

Open-Probable EEOC 2000

Open - Probable Gvt Invest 1000

=SUMPRODUCT((F2:F5="Open - Active")*(G2:G5<"Gvt Invest")*(H2:H5))

I get 1000 'cause only F2:J2 meet the criteria.


Gord

On Thu, 5 Jan 2012 15:47:48 -0800 (PST), Michelle
wrote:

I have another question: How do I get a sum total of cells if the
cells meet certain criteria? meaning, ony add the reserve to the total
if the status is Open - Active and the Nature of Case is NOT
Government Investigations?

F H J
STATUS NAT OF CAST RESERVE

Open - Active EEOC 1000

Open - Active Gvt Invest 2000

Open-Probable EEOC 2000

Open - Probable Gvt Invest 1000

Please note Isabelle's use of the double unary -- which is the
correct method.

I forgot to enter it in my formula.

Should have been

=SUMPRODUCT(--(F2:F5="Open - Active")*(G2:G5<"Gvt Invest")*(H2:H5))


Gord

On Thu, 05 Jan 2012 17:19:29 -0800, Gord Dibben
wrote:

=SUMPRODUCT((F2:F5="Open - Active")*(G2:G5<"Gvt Invest")*(H2:H5))

I get 1000 'cause only F2:J2 meet the criteria.


Gord

On Thu, 5 Jan 2012 15:47:48 -0800 (PST), Michelle
wrote:

I have another question: How do I get a sum total of cells if the
cells meet certain criteria? meaning, ony add the reserve to the total
if the status is Open - Active and the Nature of Case is NOT
Government Investigations?

F H J
STATUS NAT OF CAST RESERVE

Open - Active EEOC 1000

Open - Active Gvt Invest 2000

Open-Probable EEOC 2000

Open - Probable Gvt Invest 1000