NOW SOLVED. THANKS FJCC
I am keith using version 4.1.4 on windows10,
and I cant see why the following 'if' entry is only returning "s" for all 3 possible conditions:
=IF(J7-K7>0;"K";IF(J7-K7<0;"S";"S&K"))
[Solved] If statements
-
- Posts: 2
- Joined: Mon Apr 16, 2018 11:52 pm
[Solved] If statements
Last edited by keith williams on Tue Apr 17, 2018 3:43 pm, edited 2 times in total.
K.R.WILLIAMS OPENOFFICE 4.1.4 WINDOWS10
Re: if statements
I tried your formula in a spreadsheet and it works properly. Can you try it in a fresh document? If it still doesn't work, please upload an example file. To do that, click Post Reply and look for the Upload Attachment tab under the box where you type a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 2
- Joined: Mon Apr 16, 2018 11:52 pm
Re: If statements
thanks FJCC. Yes, as you say i copied it to a new file and it worked perfectly. I don't know what I had done to the original sheet, but thank you
K.R.WILLIAMS OPENOFFICE 4.1.4 WINDOWS10