Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    74

    Unanswered: Basic formula issue.. Stuck

    I have the following formula.


    =IF(D10>(C10+20),"B",IF(D10<=C10,"G"))


    Basically if the value of Cell D10 is = to C10 + 20, I want to place a "B" in my cell. If D10 is Less Than or Equal To C10 I want a "G" placed in my cell.

    When I type the numbers in the cells i get the following results:
    If D10 is Greater than C10 the formula does not work and the value in the cell is "FALSE".

    If D10 is Less Than or Equal To C10, the formula works

    I hope this makes sense, any ideas?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Try this
    Code:
    =If(D10=C10+20, "B", If(D10<=C10, "G", ">C10"))
    George
    Home | Blog

Posting Permissions

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