Working on a project and found this error in the formula. The IF formula is L15>I15 which in this case is TRUE but the logical test is showing False. Any ideas on why?Excel 2016

RavenDawn Change the number format to "General" to see what real values are.

Forum Discussion

Copper Contributor

Apr 13, 2019

Incorrect return on excel IF formula

Working on a project and found this error in the formula. The IF formula is L15>I15 which in this case is TRUE but the logical test is showing False. Any ideas on why?

Excel 2016

excel

1 Reply

Detlef_Lewin
Silver Contributor
Apr 13, 2019
RavenDawn
Change the number format to "General" to see what real values are.