This simple IF(J2="true",e2,g2) doesn't work.

[yabi100]

What is wrong with this formula in this table?
IF(J2="true",e2,g2)

 

[Peter_SSs]

What is wrong with this formula in this table?

Assuming the col J values are logical values and not text values, then the "TRUE" should not have the quote marks

=IF(J2=TRUE,E2,G2)

But you don't need the TRUE at all, try

=IF(J2,E2,G2)

 

[yabi100]

Assuming the col J values are logical values and not text values, then the "TRUE" should not have the quote marks

=IF(J2=TRUE,E2,G2)

But you don't need the TRUE at all, try

=IF(J2,E2,G2)

True is a logical a value. Result of =ISNUMBER(Sheet1!$E2)
But your solution didn't solve the problem. Is there any idea how can I solve this issue?
It is very odd that, even it has a = sign at the beginning, but it doesn't change into formula and remains as it is a text.

 

[yabi100]

one more question, although it is not related to IF command.
My table doesn't have blank cells, but when I make a pivot table, blanks appear both in rows and columns. What does it mean and how can I solve this issue?

 

[yabi100]

Assuming the col J values are logical values and not text values, then the "TRUE" should not have the quote marks

=IF(J2=TRUE,E2,G2)

But you don't need the TRUE at all, try

=IF(J2,E2,G2)

The problem is not with IF command as no other IF command works. This table doesn't accept any formula, even F2=E1+E2. I should look for formula input options.

 

[Cubist]

Your cells are most likely formatted as Text. Change to General and re-enter the formula again.

 

[yabi100]

Your

Your cells are most likely formatted as Text. Change to General and re-enter the formula again.

Thanks. That was the source of the problem and now solved.