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 ? |
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) |