CODEWITHSUNDEEP
excel
smirnoff103
smirnoff103

Reputation: 328

Check for specific formula (no VBA)

Is it possible to check if cell formula is a specific formula, and not just "isformula" ?

My example: In cell A1 I have, normally, "=B2". But during the use of this sheet the formula might be overwritten to "=D4". How can I get a simple TRUE result if the formula in cell A1 is "=D4", and FALSE if it's something else ?

I can fix it with VBA but I prefer to use standard formulas first (if it's possible obviously). Thanks for your time.

Upvotes: 3

Views: 70

Answers (1)

BigBen
BigBen

Reputation: 49998

Using FORMULATEXT:

=FORMULATEXT(A1)="=D4"

enter image description here

Upvotes: 3

Related Questions