SOLVED

IF function for cells with strikethrough

%3CLINGO-SUB%20id%3D%22lingo-sub-1618081%22%20slang%3D%22en-US%22%3EIF%20function%20for%20cells%20with%20strikethrough%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618081%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wonder%20if%20anyone%20here%20would%20know%20how%20to%20do%20this.%20As%20per%20the%20subject%2C%20I%20happen%20to%20have%20a%20couple%20cells%20with%20strikethrough%20that%20I%20need%20to%20use%20in%20an%20IF%20function.%20The%20argument%20should%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20cell%20X%20has%20a%20strikethrough%2C%20I%20want%20the%20formula%20to%20return%20A%2C%20otherwise%20(if%20false)%20then%20it%20should%20be%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaniel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1618081%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1618141%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%20for%20cells%20with%20strikethrough%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618141%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774335%22%20target%3D%22_blank%22%3E%40danz120488%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20has%20been%20answered%20in%20another%20forum%26nbsp%3B%3C%2FP%3E%3CP%3Ehere%20is%20the%20link%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fen-US%2Fb6f87e3c-fe87-4843-909d-a7ef6d2991e8%2Fvba-excel-to-determine-if-a-partial-strikethrough-of-text-in-a-cell-is-true%3Fforum%3Dexceldev%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Fen-US%2Fb6f87e3c-fe87-4843-909d-a7ef6d2991e8%2Fvba-excel-to-determine-if-a-partial-strikethrough-of-text-in-a-cell-is-true%3Fforum%3Dexceldev%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20implemented%20it%20for%20you%20in%20the%20following%20sheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1621952%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%20for%20cells%20with%20strikethrough%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621952%22%20slang%3D%22en-US%22%3E%3CP%3EWorks%20like%20magic%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40Ramiz_Assaf%3C%2FA%3E%26nbsp%3B%2C%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all,

 

I wonder if anyone here would know how to do this. As per the subject, I happen to have a couple cells with strikethrough that I need to use in an IF function. The argument should be:

 

If cell X has a strikethrough, I want the formula to return A, otherwise (if false) then it should be B.

 

Thanks and regards,

 

Daniel

2 Replies
Highlighted
Best Response confirmed by danz120488 (New Contributor)
Solution

@danz120488 

this has been answered in another forum 

here is the link

 

https://social.msdn.microsoft.com/Forums/en-US/b6f87e3c-fe87-4843-909d-a7ef6d2991e8/vba-excel-to-det...

 

I implemented it for you in the following sheet

 

 

Highlighted

Works like magic @Ramiz_Assaf , thanks!