This formula will display the results you want of a cell *other* then the
cell that contains this formula:

=A1*(-(A1<3)+(A1=3))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"B LO" wrote in message
...
I needed to know how or what easy way to create formulas. I wanted to to
create a cell that shows if I enter a number less than three it will show
as
negitive and of coruse if it three or higher it stays in the positve?
--
Looking for help.