Discussion IF formula not correctly displaying in Excel
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592531#M157713
<P>I am currently attempting to troubleshoot an IF formula statement. I am trying to filter out different numbers from 2 separate columns. I would like to keep all values between 1000 and 10000, with a special property given to numbers in cell P that are higher than the value in cell O while still under the range of >10000. My current If statement is: =IF(AND(P2>1000,P2>O2,P2<10000),P2,O2). I have tested this on an older version of Excel for Mac, and on Google Sheets and both work properly. Only when I am on Excel for windows does it not work (Version 2206. I have gone through each of the logicals separately and have concluded that O2<10000 is the only one that displays incorrectly.</P><P>O2: 4000 P2: 4500 (Needs to display column P) [Displays O2]</P><P>O2: 4000 P2: 0 (Needs to display O) [Displays O2]</P><P>O2: 4000 P2: 20000 (Needs to display O) [Displays O2]</P><P>O2: 4000 P2: 400 (Needs to display O) [Displays O2]</P><P>EDIT: Formula has been corrected. Still wrong, but more akin to my actual setup</P><P> </P>Fri, 05 Aug 2022 17:57:17 GMTChristianMaurer2022-08-05T17:57:17ZIF formula not correctly displaying
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592531#M157713
<P>I am currently attempting to troubleshoot an IF formula statement. I am trying to filter out different numbers from 2 separate columns. I would like to keep all values between 1000 and 10000, with a special property given to numbers in cell P that are higher than the value in cell O while still under the range of >10000. My current If statement is: =IF(AND(P2>1000,P2>O2,P2<10000),P2,O2). I have tested this on an older version of Excel for Mac, and on Google Sheets and both work properly. Only when I am on Excel for windows does it not work (Version 2206. I have gone through each of the logicals separately and have concluded that O2<10000 is the only one that displays incorrectly.</P><P>O2: 4000 P2: 4500 (Needs to display column P) [Displays O2]</P><P>O2: 4000 P2: 0 (Needs to display O) [Displays O2]</P><P>O2: 4000 P2: 20000 (Needs to display O) [Displays O2]</P><P>O2: 4000 P2: 400 (Needs to display O) [Displays O2]</P><P>EDIT: Formula has been corrected. Still wrong, but more akin to my actual setup</P><P> </P>Fri, 05 Aug 2022 17:57:17 GMThttps://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592531#M157713ChristianMaurer2022-08-05T17:57:17ZRe: IF formula not correctly displaying
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592540#M157715
<P>My first thought was to check that the 4500 in B2:4500 is entered as a number and not text. This happens to me sometimes when I copy numbers from another source. Should be no leading apostrophe ('), no spaces, etc. Also, highlight all the cells and explicitly define them as a number.</P>Fri, 05 Aug 2022 17:33:31 GMThttps://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592540#M157715ScottLamond2022-08-05T17:33:31ZRe: IF formula not correctly displaying
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592541#M157716
I thought it was that at first because of the way I was pulling the information, but I tested it separately.Fri, 05 Aug 2022 17:33:14 GMThttps://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592541#M157716ChristianMaurer2022-08-05T17:33:14ZRe: IF formula not correctly displaying
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592560#M157722
The issue I sometimes experience is if I enter data into a cell that was not in the original range selection. I'm now in the habit of making sure I insert a row between the top and bottom cells, since the software is designed to assume that I want it in the total.Fri, 05 Aug 2022 17:58:11 GMThttps://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592560#M157722ScottLamond2022-08-05T17:58:11ZRe: IF formula not correctly displaying
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592561#M157723
Another issue might involve cells that are merged, since it will assume you want the data from the left-most cell, which might be empty.Fri, 05 Aug 2022 17:59:48 GMThttps://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592561#M157723ScottLamond2022-08-05T17:59:48ZRe: IF formula not correctly displaying
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592565#M157724
Formula logic is where I waste most of my time. I suggest working on some other project for an hour and then coming back to it when your brain has been reconfigured.Fri, 05 Aug 2022 18:02:26 GMThttps://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592565#M157724ScottLamond2022-08-05T18:02:26ZRe: IF formula not correctly displaying
https://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592569#M157725
I was able to reconfigure the formula in a new sheet. It must have something to do with the values not being displayed correctly. I should be able to figure it out given some time. Just need to display the formula values as normal values. Thank you.Fri, 05 Aug 2022 18:05:15 GMThttps://techcommunity.microsoft.com/t5/excel/if-formula-not-correctly-displaying/m-p/3592569#M157725ChristianMaurer2022-08-05T18:05:15Z