Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help needed
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 ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help needed
=IF('game 1+16'!C18=1,"Win","Lose")
Maybe this: =IF('game 1+16'!C18="","",IF('game 1+16'!C18=1,"Win","Lose")) -- Biff Microsoft Excel MVP "stevenkeen" wrote in message ... 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 ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help needed
Try
=IF('game 1+16'!C18,IF('game 1+16'!C18=1,"Win","Lose"),"") -- If this helps, please click the Yes button. Cheers, Shane Devenshire "stevenkeen" wrote: 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
IF AND Formula Help Needed | Excel Discussion (Misc queries) | |||
formula needed | Excel Discussion (Misc queries) | |||
Little more help needed for my IF formula | Excel Discussion (Misc queries) |