formula help needed

S

stevenkeen

new to spreedsheets and a bit stuck

i'm doing a spreedsheet of results for a snooker league. i'm doing a form
table from the results but having a problem i need a formula
the formula i have is
=IF('game 1+16'!C18=1,"Win","Lose")
which takes the result ie 1 point for win 0 for lose and turns it to 1=Win
and 0=Lose
the problem i have is if no data is entered on result page (1/0)(ie field
blank) meaning they didn't play in that game it still comes up with a lose on
form page even though no data was entered how can i keep it blank ?
 
T

T. Valko

=IF('game 1+16'!C18=1,"Win","Lose")

Maybe this:

=IF('game 1+16'!C18="","",IF('game 1+16'!C18=1,"Win","Lose"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help removing extra TOC text from number lists used as TOC levels 0
Formula help please 1
Problem with formula for finding last greater than/less than or equal to value 2
Formula help needed 1
Sorting 3
Conditional Count Formula 3
Formula Help Needed . . 11
Formula than understands midnight? 26

Top