Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNumber - What Context?
I have created a premiership Predictascore spreadsheet where points are awarded for correct scores and/or results. I need all the scores to be set to zero so that there are no points at all. A line from one of the sheets is as follows: =IF('Master Copy'!C3+'Master Copy'!E3=Ron!C4+Ron!E4,5,0) Which returns a value of 5. In what context do I use ISNUMBER and what do I type to get the value to be 0 but change once the score has been inputted into the master copy sheet? -- ronaldo444 ------------------------------------------------------------------------ ronaldo444's Profile: http://www.excelforum.com/member.php...o&userid=36233 View this thread: http://www.excelforum.com/showthread...hreadid=571362 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNumber - What Context?
Perhaps:
=IF('Master Copy'!C3 = "","",'Master Copy'!C3+'Master Copy'!E3=Ron!C4+Ron!E4,5,0)) HTH, Bernie MS Excel MVP "ronaldo444" wrote in message ... I have created a premiership Predictascore spreadsheet where points are awarded for correct scores and/or results. I need all the scores to be set to zero so that there are no points at all. A line from one of the sheets is as follows: =IF('Master Copy'!C3+'Master Copy'!E3=Ron!C4+Ron!E4,5,0) Which returns a value of 5. In what context do I use ISNUMBER and what do I type to get the value to be 0 but change once the score has been inputted into the master copy sheet? -- ronaldo444 ------------------------------------------------------------------------ ronaldo444's Profile: http://www.excelforum.com/member.php...o&userid=36233 View this thread: http://www.excelforum.com/showthread...hreadid=571362 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add items to context menu | Excel Worksheet Functions | |||
Getting a Function not defined in VBA editor for IsNumber() | Excel Discussion (Misc queries) | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
send to mail all the context | Excel Discussion (Misc queries) | |||
send tomail all the context | Excel Discussion (Misc queries) |