Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    13

    Unanswered: Formula displaying wrong result

    Hi

    I have a formula:

    =IF($D$12:$G$12="18mm Flat",$E25+22,$E25+45)

    Basically if the range of cells D12 to G12 has the text "18mm Flat" in it, then the answer should be the value of the corresponding E cell + 22. When I use the function wizard for this, it tells me that the formula result is 22 (cell E25=0). However, when I actually look at the spreadsheet, the answer shown is 45.

    Why is this and how can I correct it?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Could you give a sample row?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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