Code: Select all
=IF(M17>N17;"Y";IF(M17<N17;"N";""))[Solved] How is this not right?
-
keithbakerlv
- Posts: 11
- Joined: Fri Mar 10, 2017 12:57 am
[Solved] How is this not right?
I have the number 3 in M17 and the number 2 in N17 and the code in O17. It isn't changing if I change the numbers though. 017 remains N no matter what.
Last edited by keithbakerlv on Wed May 29, 2019 2:50 am, edited 1 time in total.
OpenOffice 4.1.3 on Windows 10 Pro
Re: How is this not right?
Perhaps one of the entries is not a number but text. Select the menu View -> Value Highlighting. Are both M17 and N17 blue? If they are being produced by formulas, what are the formulas.
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.
-
keithbakerlv
- Posts: 11
- Joined: Fri Mar 10, 2017 12:57 am
Re: How is this not right?
Well son of a... thanks. What a stupid mistake.
OpenOffice 4.1.3 on Windows 10 Pro