IF function for cells with strikethrough

[danz120488]

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 · Accepted 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

[#3]

Works like magic @Ramiz_Assaf , thanks!