# Solved Excel greater and less than

December 10, 2016 at 10:11:03
Specs: Windows 10
 I am writing a formula to calculate a handicap for a sport. The result of the calculation cannot be less than zero or greater than 8.my formula to calc the handicap is (ab-40)*0.8how do I put in the not less than 0 or greater than 8 rule?

See More: Excel greater and less than

#1
December 10, 2016 at 10:47:45
 There are two symbols on your keyboard < > which you use as greater than > and less than <

Reply ↓  Report •

#2
December 10, 2016 at 14:33:57
✔ Best Answer
 Your going to need both an IF() an AND() function, something like:=IF(AND((ab-40)*0.8>0,(ab-40)*0.8<8),"Pass","Fail")Although your calculation will have to be modified so Excel will understand it.(ab-40)*0.8 is not a valid Excel calculation.And Excel questions are best asked in the Office Software forum.MIKEmessage edited by mmcconaghy

Reply ↓  Report •

#3
December 10, 2016 at 16:21:26
 thanks, I knew that, just couldn't get a formula to work. I have since worked it out. thanks again

Reply ↓  Report •

Related Solutions