# Calc: use + / - statement for calculation

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:
- 2010-12-19

- Last reply:
- 2010-12-19

mycae (mycae) said : | #1 |

try

=IF(A1<0; A1-B1;A1+B1)

mycae (mycae) said : | #2 |

Oops.

I think they use comma's now -- though the separator may depend upon your locale.

=IF(A1<

karlrt (karlrt) said : | #3 |

didnt think of an easy if statement, thanks for this simple solution, but somehow it doesnt work as expected:

with ; as seperator, it gives #NAME?

with , it just states Err:501

dont know what is wrong, just to get it right i even tried an easy example: http://

mycae (mycae) said : | #4 |

make sure that your values are actually entered in as numerical data, rather than text

For example, I opened a new file, typed in 123 in A1, -123 in A2, then put the following formula in C1

=IF(A1<

This gives the expected answer of 246.

marcus aurelius (adbiz) said : | #5 |

Format > Cells > Numbers then accounting

want to learn how to use openoffice? the manuals are here

http://

## Can you help with this problem?

Provide an answer of your own, or ask karlrt for more information if necessary.