IF function showing False when True

%3CLINGO-SUB%20id%3D%22lingo-sub-2067796%22%20slang%3D%22en-US%22%3EIF%20function%20showing%20False%20when%20True%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067796%22%20slang%3D%22en-US%22%3E%3CP%3EIF%20function%20shown%20in%20top%20bar%20is%20showing%20as%20False%20(20%2B77)%3D97%20should%20show%20true%20answer.%20Unsure%20why%2C%20any%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E20%20and%2077%20are%20taken%20from%20another%20cell%20which%20is%20a%20%3Dsum%20function%20to%20total%20up%2C%20was%20unsure%20if%20this%20had%20anything%20to%20do%20with%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20appreciated%2C%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2067796%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067833%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%20showing%20False%20when%20True%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067833%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931785%22%20target%3D%22_blank%22%3E%40cmwilliams_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20worth%20checking%20whether%26nbsp%3BV5%2BW5-O5%20is%20zero.%26nbsp%3B%20Checks%20like%20this%20work%20with%20whole%20numbers%20but%20decimal%20numbers%20will%20introduce%20small%20rounding%20errors.%26nbsp%3B%20If%20there%20is%20such%20error%2C%20a%20suitable%20test%20might%20be%3C%2FP%3E%3CP%3E%3D%20ABS(V5%2BW5-O5)%26lt%3B0.0001%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

IF function shown in top bar is showing as False (20+77)=97 should show true answer. Unsure why, any help would be appreciated.

 

20 and 77 are taken from another cell which is a =sum function to total up, was unsure if this had anything to do with it?

 

Any help appreciated, thanks.

2 Replies

@cmwilliams_ 

It would be worth checking whether V5+W5-O5 is zero.  Checks like this work with whole numbers but decimal numbers will introduce small rounding errors.  If there is such error, a suitable test might be

= ABS(V5+W5-O5)<0.0001

 

@Peter Bartholomew 

 

Hi Peter,

 

Just put that in there as a check, its coming back as TRUE.

 

Managed to figure out the rounding error was abit further down the line, so I've added a round function to the O5 to get rid of that and its now working!

 

Thanks for you help.