If Function Possibilities

  • Thread starter Thread starter rheller
  • Start date Start date
R

rheller

Is there a way to set up in a cell A1, something like...

If the formula used in cell B1 is "here I would type the actual formula
in,"
then display the words "works," else display "mistake"


?
 
That's a pretty cryptic post. Do you mean:

In A1:

=IF(B1=n,"Works","Mistake") where 'n' is the desired result of th
formula in B1?

so that if B1 is =2*4

and your formula in A1 is =IF(B1=8,"Works","Mistake") , A1 would sho
"Works"

HT
 
Not sure if this is whatyou are looking for but I frequently use this
in my vlookups:

=If(ISNA(vlookup()),"mistake",vlookup(works))

You can also use =IF(iserr(yourFormula),mistake,works)
 
Back
Top