Forum Discussion

thecurlyscholar's avatar
thecurlyscholar
Copper Contributor
Dec 15, 2023

Trying to use equation In excel but keep receiving false message

Spoiler
 

Hi all,

 

I am trying to submit =AI29=AJ29 into excel and it gave me a false message. I then tried to submit =IF(AI29=AJ29,TRUE,"") and it completely deletes the message. Im not sure what else to do. Im trying to use the y=mx+b equation from the graph in excel, to plug the y values back into x to solve for x, in order to check for continuity. 

 

If you could help, I would appreciate it!

excel
Excel on Mac
Formulas and Functions

2 Replies

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 15, 2023

    thecurlyscholar 

    What do you mean by "it completely deletes the message"? The formula you mention would return a blank when it evaluates to a FALSE.

     

    If the formula =AI29=AJ29 returns FALSE, it simply means that the two cell do NOT contain the exact same value. Are the both numbers, texts? Perhaps there are leading or trailing spaces in one or both but not in the same place.

    • Khai's avatar
      Khai
      Copper Contributor
      Nov 21, 2024

      I have faced the same issue, so what to do for this. I have checked the length for the numbers while it is not same 

Resources