URGENT HELP - SUM FORMULA
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
|