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"
?
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 the formula in B1?
so that if B1 is =2*4
and your formula in A1 is =IF(B1=8,"Works","Mistake") , A1 would show "Works"
HTH
Bruce
The older I get, the better I used to be.
USA
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks