+ Reply to Thread
Results 1 to 3 of 3

If Function Possibilities

  1. #1
    Registered User
    Join Date
    06-06-2005
    Posts
    5

    If Function Possibilities

    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"


    ?

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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

  3. #3
    comish4lif@verizon.net
    Guest

    Re: If Function Possibilities

    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)


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1