Checking correct formula

[csteph12]

I am trying to run a formula that checks the correct text, specifically the correct formula has been entered in an active cell. So far my best attempt has been =IF(A1="=A4+A5", Yes, No), I have also tried it just with the letters. I am using Excel 2003.

 

[id107]

What is in A1, A4 and A5? Is this the sort of thing you're looking for?

<TABLE cellSpacing=0 border=1><TBODY><TR vAlign=bottom><TH width=22 bgColor=#b0b0b0> </TH><TH align=middle width=62 bgColor=#b0b0b0>A</TH><TH align=middle width=62 bgColor=#b0b0b0>B</TH><TH align=middle width=62 bgColor=#b0b0b0>C</TH></TR><TR vAlign=bottom><TH align=middle bgColor=#b0b0b0 height=12>1</TH><TD>pies</TD><TD> </TD><TD>Yes</TD></TR><TR vAlign=bottom><TH align=middle bgColor=#b0b0b0 height=12>2</TH><TD> </TD><TD> </TD><TD> </TD></TR><TR vAlign=bottom><TH align=middle bgColor=#b0b0b0 height=12>3 </TH><TD> </TD><TD> </TD><TD> </TD></TR><TR vAlign=bottom><TH align=middle bgColor=#b0b0b0 height=12>4 </TH><TD>pi</TD><TD> </TD><TD> </TD></TR><TR vAlign=bottom><TH align=middle bgColor=#b0b0b0 height=12>5 </TH><TD>es</TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>
If it is, then =IF(A1=A4&A5,"Yes","No")
If it's not, please give more info. Ta

 

[VoG]

It isn't easy to use a formula to check the formula in another cell. One (convoluted) way is do define a Name referring to an old XLM function GET.CELL. Easier is to use a User Defined Function in a regular module

Function fmla(r As Range) As String
fmla = r.Formula
End Function

Then to use it

Sheet1

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td style="border: 3px outset rgb(240, 240, 240);">A</td><td style="border: 3px outset rgb(240, 240, 240);">B</td></tr><tr style="height: 18px;"><td style="border: 3px outset rgb(240, 240, 240); background-color: rgb(202, 202, 202); text-align: center;">1</td><td style="text-align: right;">6</td><td>Yes</td></tr></tbody></table>
<table style="font-family: Arial; font-size: 10pt; border-style: groove; border-color: rgb(0, 255, 0); background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>A1</td><td>=A4+A5</td></tr><tr><td>B1</td><td>=IF(fmla(A1)="=A4+A5", "Yes", "No")</td></tr></tbody></table></td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4

 

[csteph12]

Thanks alot VOG the formula work exactly how I needed it to

Craig

 

[VoG]

Glad that it worked, given my minimalist instructions