What's the deal here? thanks
 

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

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

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

What's the deal here? thanks
 

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

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

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

What's the deal here? thanks
 

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

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

"Bernard Liengme" wrote in message
...
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

What's the deal here? thanks
 

Is it monday where you live too. <g After that great expanation you mess up
a bracket. Ain't that just the way...
--
HTH...

Jim Thomlinson


"Bernard Liengme" wrote:

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

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

"Bernard Liengme" wrote in message
...
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