View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default What's the deal here? thanks

As copied, I had errors. This seemed to work:
=IF(H3D3,CHAR(233),IF(H3<D3,CHAR(234),IF(H3=D3,CH AR(109))))

If D3 & H3 are numbers, maybe:
=CHOOSE(SIGN(H3-D3)+2,"ê","m","é")

--
Dana DeLouis


"pgarcia" wrote in message
...
=IF((H3D3, CHAR(233)),if (H3<D3, CHAR(234)),if (H3=D3, CHAR(109)))

Shouldn't this work or what am I missing? thanks