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