Hi all,
Excel Guru's I need help please.
I'm trying to write a formula for a spreadsheet of results I keep for our local pool team matches. Below is an example of what I have:
=IF(BO6>=7,"WIN","LOST")
This explained is if BO6 is equal to or greater then the value of 7 display the word WIN, if not display LOST.
However due to new rule changes I need to change this, so basically what I want is
IF BO6 > BP6 = "WIN", IF BO6 < BP6 = "LOST", IF BO6 = BP6 = "DRAW".
Can anyone help me out with the Syntax I should use?
Excel Guru's I need help please.
I'm trying to write a formula for a spreadsheet of results I keep for our local pool team matches. Below is an example of what I have:
=IF(BO6>=7,"WIN","LOST")
This explained is if BO6 is equal to or greater then the value of 7 display the word WIN, if not display LOST.
However due to new rule changes I need to change this, so basically what I want is
IF BO6 > BP6 = "WIN", IF BO6 < BP6 = "LOST", IF BO6 = BP6 = "DRAW".
Can anyone help me out with the Syntax I should use?