IF Function in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1661461%22%20slang%3D%22en-US%22%3EIF%20Function%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661461%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone!%3C%2FP%3E%3CP%3EI%20need%20a%20little%20guidance%20from%20you%20people.%20I%20want%20to%20use%20IF%20Function%20of%20Excel%20but%20my%20cell%20already%20contain%20symbol%20%22%20.%20What%20should%20I%20do%20so%20that%20my%20function%20can%20work%20because%20excel%20isn't%20picking%20two%20%22%20symbols%20at%20a%20time.%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20knows%20who%20can%20help%20me%20through%20this%3F%3C%2FP%3E%3CP%3EIt%20will%20be%20highly%20appreciated.%20Thanks.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20444px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F218018i83AC387DCD867038%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1661461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661642%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661642%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20this%20case%20you%20can%20just%20put%20a%20third%20quotation%20mark%20at%20the%20end%20of%20it%20and%20it%20will%20close%20out%20that%20reference%20to%20match%20the%20cell%20properly.%20Otherwise%20to%20make%20it%20simpler%20you%20could%20put%20that%20value%20of%201%2F2%22%20in%20a%20reference%20cell%20somewhere%20else%20in%20the%20workbook%20and%20call%20it%2Freference%20it%20(%24G%241...or%20label%20the%20reference%20%22.5Measure%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(C5%3D%221%2F2%22%22%22%2C%20TRUE%20RESULT%2C%20FALSE%20RESULT)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello Everyone!

I need a little guidance from you people. I want to use IF Function of Excel but my cell already contain symbol " . What should I do so that my function can work because excel isn't picking two " symbols at a time. 

Anyone knows who can help me through this?

It will be highly appreciated. Thanks.

Capture.PNG

 

1 Reply
Highlighted

In this case you can just put a third quotation mark at the end of it and it will close out that reference to match the cell properly. Otherwise to make it simpler you could put that value of 1/2" in a reference cell somewhere else in the workbook and call it/reference it ($G$1...or label the reference ".5Measure". 

 

=IF(C5="1/2""", TRUE RESULT, FALSE RESULT)