Excel formula help

Discussion in 'OT Technology' started by Dustro, Apr 21, 2005.

  1. Dustro

    Dustro New Member

    Joined:
    Nov 1, 2003
    Messages:
    2,123
    Likes Received:
    0
    Location:
    NC
    ok im needing to add a formula to an excel sheet I have using probally either the countif or if funtion to look at cell XX and return a 1 if the value is less than or equal to 75 and return a 0 if it is greater than or equal to 76. All the formulas I have came up with will work except when the cell value is 100 or greater..

    this is my current
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    =if(xx<=75,0,1)

    And your logic doesn't really make sense unless you want to avoid values between 75 and 76
     
  3. 01000101

    01000101 New Member

    Joined:
    Jul 8, 2003
    Messages:
    642
    Likes Received:
    0
    theres also a wizard for conditional formating.

    but to do it manual:
    =if(logic_test,value_true,value_false)
     

Share This Page