formula help needed

  • Thread starter Thread starter stevenkeen
  • Start date Start date
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 ?
 
=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

Excel Handicap Formula 0
Formula help please 1
Excel Need Countifs Formula Help 0
Formula Help Needed . . 11
How to SUM TWO ARRAY formula results 4
Sorting 3
if(and(isblank( formula help 2
how to make a formula ignore blank cells 6

Back
Top