show only the negative total

[jv]

Good evening,

Can you help me make a formula showing only the negative
amount in column F or the one exceed from the budget

A B C D E F
Budget 1st-Wk 2nd-Wk 3rd-Wk 4th-Wk Total

29,500 3,500 7,500 13,000 4,500
13,000 7,000 7,500 7,500 7,000 -16,000
3,500 1,000 500 200 300
800 500 3,000 500 850 - 4,050
--------
Over Expense: 20,500

From the above: column F is the total of B:E, I need only
to reflect the "negative/excess amount" (column F-A) in
column F.

Thanks in advance.

jv

 

[Frank Kabel]

Hi JV

try the following in F2
=IF(A2-SUM(B2:E2)<0,A2-SUM(B2:E2),"")

HTH
Frank

 

[Ken Wright]

=MIN(0,Your_Current_Formula) formatted as accounting, or with zero values
unchecked in options, or with conditional formatting making zero values a white
font.

 

[jv]

Frank & Ken,

Once again, thanks to both of you, its really a big help
for me.

jv

 

[Ken Wright]

You are most welcome. There is a wealth of info contained within the groups
that can often be found very simply with a quick Google Search:-

http://groups.google.com/advanced_group_search?hl=en

This is something that has been made even easier if you use Ron De Bruins free
Google Search addin:-

http://www.rondebruin.nl/