Help with Value Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1726367%22%20slang%3D%22en-US%22%3EHelp%20with%20Value%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ValueError.JPG%22%20style%3D%22width%3A%20464px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222883iB2C7BF16E5C91F19%2Fimage-dimensions%2F464x275%3Fv%3D1.0%22%20width%3D%22464%22%20height%3D%22275%22%20title%3D%22ValueError.JPG%22%20alt%3D%22Value%20Error%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EValue%20Error%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20love%20the%20if%20statement%2C%20but%20am%20having%20trouble%20getting%20the%20syntax%20correct%20on%20this%20one.%20I%20know%20the%20answer%20must%20be%20super%20simple%2C%20what%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20return%20%22True%22%20where%20F-G%20%3D%20H%20and%20%22False%22%20where%20it%20does%20not%3F%3C%2FP%3E%3CP%3EExample%2C%20last%20row%20would%20be%20%22False%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1726367%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1726412%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Value%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726412%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813942%22%20target%3D%22_blank%22%3E%40BB1024%3C%2FA%3E%26nbsp%3BMake%20sure%20G2%20does%20not%20have%20a%20space%20in%20it.%20Click%20it%20and%20hit%20delete%20to%20be%20sure.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Value ErrorValue Error

I love the if statement, but am having trouble getting the syntax correct on this one. I know the answer must be super simple, what am I doing wrong?

 

Can I return "True" where F-G = H and "False" where it does not?

Example, last row would be "False"

1 Reply

@BB1024 Make sure G2 does not have a space in it. Click it and hit delete to be sure.