Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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(A1<0,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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate minus figures | Excel Discussion (Misc queries) | |||
Calculate minus figures only | Excel Discussion (Misc queries) | |||
I want to get brackets round my figures not minus signs | Excel Discussion (Misc queries) | |||
Add up Plus & Minus Figures separately by Location | Excel Worksheet Functions | |||
Not able to calculate. | Excel Worksheet Functions |