Aug 28 2020 01:59 AM
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
Aug 28 2020 02:12 AM
Solutionthis has been answered in another forum
here is the link
I implemented it for you in the following sheet
Aug 30 2020 07:06 PM
Works like magic @Ramiz_Assaf , thanks!
Aug 28 2020 02:12 AM
Solutionthis has been answered in another forum
here is the link
I implemented it for you in the following sheet