What's the deal here? thanks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Shouldn't this work or what am I missing? thanks
 
As copied, I had errors. This seemed to work:
=IF(H3>D3,CHAR(233),IF(H3<D3,CHAR(234),IF(H3=D3,CHAR(109))))

If D3 & H3 are numbers, maybe:
=CHOOSE(SIGN(H3-D3)+2,"ê","m","é")
 
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(H3>D3, CHAR(233),if(H3<D3, CHAR(234),CHAR(109)))
 
Try
=IF(H3>D3, 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(H3>D3, CHAR(233), CHAR(234)))
will treat the two numbers as equal if their difference is less than
one-millionth.

best wishes
 
THAT IT!!!

Thanks

Jim Thomlinson said:
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(H3>D3, CHAR(233),if(H3<D3, CHAR(234),CHAR(109)))
Click to expand...
 
Is it monday where you live too. <g> After that great expanation you mess up
a bracket. Ain't that just the way...
 
Back
Top