I know This has probably been asked a few times, but I can’t seem to find an answer that helps me at all. I’m aware that IF statements are not available in Writer, but for what I’m working on, unfortunately imbedded calc tables will not do the job.

I need a series of inputs that will register automatic results upon certain inputs (bonus and penalties for attributes, if you’re familiar with tabletop RPG gaming).

For example:

If the number input is 9-12 then the resulting output would be zero (“0”).

If the number input is less than 9, then the output would be -1.

If the number input is greater than 12, then the input would be +1.

I’m sorry if I appear to be a newb at this. I am certainly a newb at doing formulas in writer, and have figured out how to do this in Calc, but am still not proficient in most of the formulas beyond these basics. Any help would be most greatly appreciated.