|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 30th, 2005, 10:41 AM
|
|||
|
|||
calculate minus figures only
Can anyone help me to calculate the minus figures only in a range of random
costs? example £-2000.00 £ 1000.00 £ 560.00 £-4500.00 £-6500.00 these figures are random as per data entry to hours and cost etc. the figures are to show a loss in costs that could have been saved. i am using excell in office 2000. any help graciously appreciated. Thanks, Nigel 
|
|
#2
March 30th, 2005, 10:55 AM
|
|||
|
|||
|
Your question is unclear. Probably you want to do something if the cost is
negative. Suppose these figures are in column A starting at cell A1, then simply use =if(A10,do_this,else_do_this) put your required expressions in place of do_this and else_do_this Mangesh -- Message posted via http://www.officekb.com
|
|
#3
March 30th, 2005, 12:03 PM
|
|||
|
|||
|
Hi,
I have actually answered my own question but thought i'd let you all know. formula is: =sumif(range,"0") Thanks anyway, Nigel "Nigel" wrote: Can anyone help me to calculate the minus figures only in a range of random costs? example £-2000.00 £ 1000.00 £ 560.00 £-4500.00 £-6500.00 these figures are random as per data entry to hours and cost etc. the figures are to show a loss in costs that could have been saved. i am using excell in office 2000. any help graciously appreciated. Thanks, Nigel
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Calculate minus figures only | Nigel | General Discussion | 0 | March 30th, 2005 10:31 AM |
| Displaying minus figures (2) | alexa696 | General Discussion | 5 | September 22nd, 2004 09:47 PM |
| Displaying minus figures | alexa696 | General Discussion | 2 | September 22nd, 2004 09:29 PM |
| how do i get a formula to ignore minus figures | marto_martin | New Users | 2 | September 12th, 2004 12:09 PM |
Linear Mode
