| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Budget - Need to have payments always calculated as negatives
In setting up budget calcs for next year, we want to have all the
credits/payments columns calculate and show as negative nbrs. Formatting them to show as negative is easy. How do I set them to calculate as negatives too? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Budget - Need to have payments always calculated as negatives
If you calculate, use -Figure instead of Figure
-- Kind regards, Niek Otten "CSP" wrote in message ... In setting up budget calcs for next year, we want to have all the credits/payments columns calculate and show as negative nbrs. Formatting them to show as negative is easy. How do I set them to calculate as negatives too? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable Calculated Item error | Excel Discussion (Misc queries) | |||
| Finding y-Values in budget curve app w/ excel | Excel Discussion (Misc queries) | |||
| Finding y-values in budget curve app with Excel & VBA | Charts and Charting in Excel | |||
| How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions | |||
| Find and Replace | Excel Discussion (Misc queries) | |||
Linear Mode
