Forum Discussion

bellmatthias's avatar
bellmatthias
Copper Contributor
Nov 26, 2023

IF Statements with formulas

Hi,   I am trying to use an IF formula as a part of conditional formatting. The IF formula is "IF(K14=L14,TRUE,FALSE)". Every time I try to use the IF formula it says the logic is false. The two ce...
excel
Formulas and Functions
bellmatthias's avatar
bellmatthias
Copper Contributor
Nov 26, 2023
mathetes Thanks for responding. When I checked out your example, it worked perfectly fine, but when I tried to apply it to my sheet, it still calls it false. Is it possible excel is just glitching?
mathetes's avatar
mathetes
Gold Contributor
Nov 26, 2023

bellmatthias 

 

when I tried to apply it to my sheet, it still calls it false. Is it possible excel is just glitching?

 

Not likely. VERY unlikely in fact. Especially on some aspect that's been around as long as conditional formatting, it would be next to impossible that you have discovered a glitch in this routine. So let's look for what's going wrong.

 

Is it possible for you to post a copy of your spreadsheet on OneDrive or GoogleDrive, and paste a link here that grants access to it? So long as it doesn't have confidential info in it. If it does, maybe make a mockup that still illustrates the error.

    • bellmatthias's avatar
      bellmatthias
      Copper Contributor
      Nov 26, 2023
      I figured out the issue, I had removed decimal places and so the numbers weren't actually the same
      • mathetes's avatar
        mathetes
        Gold Contributor
        Nov 26, 2023

        bellmatthias 

         

        I figured out the issue, I had removed decimal places and so the numbers weren't actually the same

         

        Great! Yes. There was a glitch, but not in Excel.:smile:

         

        I see you're involved in a church, so I'm kind of assuming this may have to do with pledges vs actual giving, or something like that. Blessings!

         

        And if I can do anything more to help....don't hesitate to ask.

  • bellmatthias's avatar
    bellmatthias
    Copper Contributor
    Nov 26, 2023
    https://lenapevalleychurch-my.sharepoint.com/:f:/g/personal/matthiasb_lenapevalleychurch_org/ElDAi-1Es9NOi8waIuZSkfoB1iaJq__7l5fEjTQIfp7yRQ?e=346Bfw

Resources