Forum Discussion
ChristianMaurer
Aug 05, 2022Copper Contributor
IF formula not correctly displaying
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 ...
- Aug 05, 2022
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.
ScottLamond
Aug 05, 2022Brass Contributor
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.
ChristianMaurer
Aug 05, 2022Copper Contributor
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.