Formula ?? Please help
 

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

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

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

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

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

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

Hi Don,

What exactly do you have in the cell [P10]?

1) If it is text "-" then your, Bob and my formulae (see the responses
below) should work
2) If is is a negative value, e.g. -1 then Govind's formula should work
3) If it is a 0 formatted as "-", then none would work as the values of the
empty cell and the one that has such a "-" are the same: 0. You can check
that by changing the format of [P10] to General. One could, of course,
assume that for positive number you would enter 1, so the formula could be
=IF(P10,N10,-N10), but it seems a bit inefficient to me.

Regards,
KL


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

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

Agreed on all that, and I didn't mean to imply criticism (though on
re-reading it obviously does :-)), but unless it is a formula rich (even
obese) spreadsheet, you will never notice any benefit. You are an
experienced Excel user, which means you are not a typical Excel user, so it
seems clear to you, even obvious, but remember those who come after us <g

Regards

Bob

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

On Mon, 8 Aug 2005 18:43:02 -0700, 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

What, exactly, might be in P10?

If all that is in P10 is either "-" or not (i.e. P10 is blank), then:

=VALUE(P10&1)*N10


--ron