Formula ?? Please help

D

Don

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
 
D

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
 
K

KL

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
 
K

KL

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
 
B

Bob Phillips

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
Top