Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate # of days between dates, excluding holidays | 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 | |||
minus formel/fortegn | Excel Discussion (Misc queries) |