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

THAT IT!!!

Thanks

"Jim Thomlinson" wrote:

You are a little messed up. Your final criteria H3=D3 is not necessary as you
have already determined that it is not greate or less than (must be equal)...
Try this...

=IF(H3D3, CHAR(233),if(H3<D3, CHAR(234),CHAR(109)))
--
HTH...

Jim Thomlinson


"pgarcia" wrote:

=IF((H3D3, CHAR(233)),if (H3<D3, CHAR(234)),if (H3=D3, CHAR(109)))

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