Calc: use + / - statement for calculation
Asked by
karlrt
I have this table, representing currency values like - 7,74 or + 5,24 for accounting:
-7 48
12 10
-0 76
....
I want to recalculate them, but the but how can I get the second row to use the "-" value if its a negative booking?
Currently i use: =A2+B2/100 which works only for positive statements, for negative statements i need to use A1-B1/100
thanks for your help!
Question information
- Language:
- English Edit question
- Status:
- Answered
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask karlrt for more information if necessary.
To post a message you must log in.