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

=if(xx<=75,0,1) And your logic doesn't really make sense unless you want to avoid values between 75 and 76

theres also a wizard for conditional formating. but to do it manual: =if(logic_test,value_true,value_false)