Ask Your Question
0

In Writer formulas, is possible to use conditional "if"?

asked 2017-06-22 04:42:07 +0200

I'm creating a form and in a table, need to change values of some cells depending on another cell value.

That's I have a cell with values as A,B,C or 1. If the user type A on that cell, I need to change other cell values to recalculate other cells ... I know how to do it in Calc, but I'm trying to make a Writer only document.

Is possible to make what I'm trying?

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-22 07:46:53 +0200

pierre-yves samyn gravatar image

Hi

AFAIK only calculation with numbers are supported (see tdf#99433).

In this example Result (in B5) is -B2 if B1 = 0, result is -B3 if B1<>0

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-22 04:42:07 +0200

Seen: 32 times

Last updated: Jun 22 '17