Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Whats wrong with this formula

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    column A is a date formula $f2+1
    column c is a code number 31 or 32
    column D is the results I need.
    the formula is something like this;
    =if(sheet01!a6=f2+1,sheet01!c6=31,sheet01!e6)
    I need to check column A and B before I get the results of column D. Also when I input the formula is show something wrong with f2+1
    or the +1 part of F2
    Thanks Walt

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default


    column A is a date formula $f2+1
    column c is a code number 31 or 32
    column D is the results I need.
    the formula is something like this;
    =if(sheet01!a6=f2+1,sheet01!c6=31,sheet01!e6)
    I need to check column A and B before I get the results of column D. Also when I input the formula is show something wrong with f2+1
    or the +1 part of F2


    Walt

    =if(sheet01!a6=f2+1,sheet01!c6=31,sheet01!e6)

    means that when the condition [ sheet01!a6=f2+1 ] is true, return the result of the test whether sheet01!c6 is equal to 31, an evaluation that is bound to return either TRUE or FALSE, otherwise [that's, condition sheet01!a6=f2+1 is false ] return the value in sheet01!e6. Is this your intent?

    Regarding F2, type in empty cell

    =ISNUMBER(F2)

    and report back what this gives?

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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