Home

Incorrect return on excel IF formula

%3CLINGO-SUB%20id%3D%22lingo-sub-449979%22%20slang%3D%22en-US%22%3EIncorrect%20return%20on%20excel%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449979%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20on%20a%20project%20and%20found%20this%20error%20in%20the%20formula.%20The%20IF%20formula%20is%20L15%26gt%3BI15%20which%20in%20this%20case%20is%20TRUE%20but%20the%20logical%20test%20is%20showing%20False.%20Any%20ideas%20on%20why%3F%3C%2FP%3E%3CP%3EExcel%202016%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20342px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F108617iFC83B2F6915E18E1%2Fimage-dimensions%2F342x518%3Fv%3D1.0%22%20width%3D%22342%22%20height%3D%22518%22%20alt%3D%22Screenshot%20(7).png%22%20title%3D%22Screenshot%20(7).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-449979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-450004%22%20slang%3D%22en-US%22%3ERe%3A%20Incorrect%20return%20on%20excel%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-450004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320646%22%20target%3D%22_blank%22%3E%40RavenDawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChange%20the%20number%20format%20to%20%22General%22%20to%20see%20what%20real%20values%20are.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
RavenDawn
Occasional Visitor

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

Screenshot (7).png

1 Reply

@RavenDawn 

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

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies