[Solved] How is this not right?

Discuss the spreadsheet application

[Solved] How is this not right?

Postby keithbakerlv » Tue May 28, 2019 11:22 pm

I have the number 3 in M17 and the number 2 in N17 and the code
Code: Select all   Expand viewCollapse view
=IF(M17>N17;"Y";IF(M17<N17;"N";""))
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
keithbakerlv
 
Posts: 9
Joined: Fri Mar 10, 2017 12:57 am

Re: How is this not right?

Postby FJCC » Tue May 28, 2019 11:37 pm

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7388
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How is this not right?

Postby keithbakerlv » Wed May 29, 2019 2:50 am

Well son of a... thanks. What a stupid mistake.
OpenOffice 4.1.3 on Windows 10 Pro
keithbakerlv
 
Posts: 9
Joined: Fri Mar 10, 2017 12:57 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 40 guests