just adding an option :-) in addition, it is shorter for typing and uses no
functions. also, since I started to use it, it doesn't seem that obtuse any
longer.

regards,
KL



"Bob Phillips" wrote in message
...
Why be obtuse when you can be clear?

--
HTH

Bob Phillips

"KL" wrote in message
...
How about:

=N10*-1^(P10="-")

Regards,
KL


"Bob Phillips" wrote in message
...
How about

=IF(P10="-",-N10,N10)

--
HTH

Bob Phillips

"Don" wrote in message
...
Thank you for helping me, but that forumla did'nt work So i email you
a
copy
of my spreadsheet so you can see it and get a better idea what im
trying
to
do.

Thank you.
Don

"Govind" wrote:

Hi,

Try

=IF(P10<0,-N10,N10)

Regards
Govind.



Don wrote:
Here is the formula: If(P10="-",-N10,N10) I'm trying to get the
cell
to read
negative.
Please help with this formula I appreciate any help in advance.


Thanks
Don