Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Function IsThisOne(IsDeze1 As String, IsDeze2 As String) As Integer IsThisOne = 0 If IsDeze1 < "" Then ttt = Range(IsDeze1).Value Else ttt = "" If ttt = IsDeze2 Then IsThisOne = 1 If ttt = "" Then IsThisOne = 0 End Function What I had was that the default value is "", when a team wins WINA = value of that team "NED" So now in WINA = NED it's 1 else it's 0 Thanks to Ric and Bob for thier suggestions but I think this works just fine, now let's hope NED wins?!? Regards, Hans -- hhalle Male ------------------------------------------------------------------------ hhalle's Profile: http://www.excelforum.com/member.php...o&userid=20829 View this thread: http://www.excelforum.com/showthread...hreadid=497844 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Comparing cell contents with different reference cells | Excel Worksheet Functions | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |