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

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

But beware of the so-called IEEE rounding error. If calculations are
involved you may get values like H3=10 and D3=9.99999999999999. You will
expect CHAR(109) but will get CHAR(233)

=IF(ABS(H3-D3)<1E-6, CHAR(109), IF(H3D3, CHAR(233), CHAR(234)))
will treat the two numbers as equal if their difference is less than
one-millionth.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"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