Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
3 Posts
Discussion Starter · #1 ·
Hi All,

Have been searching round the internet for a while and cannot find the answer to my problem so thought I would join here see if anyone can help out??

I want to have a cell that states HW (for Home Win) D (for Draw) and AW (for Away Win) based on a points score in another cell, however cannot seem to get it to work for the draw based on a negative value.

Example 1

Home Team - Points Score 500
Away Team - Points Score 300
Diff - +200
Result - HW

Home Team - Points Score 500
Away Team - Points Score 490
Diff - +10
Result - D

Home Team - Points Score 490
Away Team - Points Score 500
Diff - -10
Result - D

Home Team - Points Score 300
Away Team - Points Score 500
Diff - -200
Result - AW

However, I want the range for the draw to be between -50 & 50 but cannot seem to get the nested IF function to return the negative number. The formula I have for home and away are;

IF=(K8>0;"HW";IF(K8<0;"AW"))

Which would work fine, I just cannot work out how to get the between -50 & +50 range that would return a result of "D" for the draw

You help is appreciated in advance :)
Thanks
:up:
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top