Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Nigel
 
Posts: n/a
Default Calculate minus figures only

i need to know how to do the following calculation. i need to calculate the
minus figures only and leave to positive figures. these figures are inserted
random so i cannot select specific cells. example as follows:

£-1500.00 these figures are inserted as random figures based on other data
entry
£ 2000.00 from differetn cells and calculated thus giving current balance.
£ 1246.00 i only need the minus figures calculated to show loss
£- 600.00

£ 2100.00 Total

Help most appreciated. i am using excell in office 2000.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to calculate # of days between dates, excluding holidays abs2299 Excel Discussion (Misc queries) 8 March 3rd 05 02:21 AM
I want to get brackets round my figures not minus signs Peru Excel Discussion (Misc queries) 3 February 3rd 05 09:30 PM
Add up Plus & Minus Figures separately by Location John Excel Worksheet Functions 2 January 21st 05 09:40 AM
Not able to calculate. mark_kramarczyk Excel Worksheet Functions 1 December 29th 04 08:55 PM
minus formel/fortegn Bella Excel Discussion (Misc queries) 1 December 15th 04 08:37 PM


All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"