show only the negative total

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

Hi JV

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

HTH
Frank

jv wrote:
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

=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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Frank Kabel" wrote in message
...
Hi JV

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

HTH
Frank

jv wrote:
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.562 / Virus Database: 354 - Release Date: 16/01/2004

Frank & Ken,

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

jv



-----Original Message-----
=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.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Frank Kabel" wrote in message
...
Hi JV

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

HTH
Frank

jv wrote:
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.562 / Virus Database: 354 - Release Date:
16/01/2004


.

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/

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"jv" wrote in message
...

Frank & Ken,

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

jv



-----Original Message-----
=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.

--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------
------------------



"Frank Kabel" wrote in message
...
Hi JV

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

HTH
Frank

jv wrote:
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.562 / Virus Database: 354 - Release Date:
16/01/2004


.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.562 / Virus Database: 354 - Release Date: 16/01/2004