If Function Possibilities

Tech-Archive recommends: Speed Up your PC by fixing your registry


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"


?


--
rheller
------------------------------------------------------------------------
rheller's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24081
View this thread: http://www.excelforum.com/showthread.php?threadid=377045

.

Relevant Pages

  • Re: Autopopulating a cell
    ... an entry into the a1 cell. ... Tralee6 ... Tralee6's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29273 ... Prev by Date: ...
    (microsoft.public.excel)
  • Array Reference
    ... value of a cell? ... accross. ... anar_baku's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18259 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Help
    ... Use the 'Goal seek' option on the 'Data' menu to find the value of cell ... Deadloss ... Deadloss's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29859 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Adding a column
    ... If there is only one number in cell it is counted, if 2, then the one ... in parentheses is the only one of the 2 counted. ... roger_home's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16434 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: How to count sets of numbers
    ... each cell contains a single digit, a 1, 2 or 3. ... ...the results I am looking for would resemble something like this: ... JimDandy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16578 ...
    (microsoft.public.excel.charting)