=+

[Guest]

What does "=+celladress" mean & do ?

 

[Guest]

Turns any number to positive

Tim

 

[Bob Phillips]

it is a throwback to Lotus and is redundant.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Dave Peterson]

=A1
(the + isn't required)

retrieves the value from A1 in that same worksheet.

If A1 is empty, excel will return a 0.

=if(a1="","",a1)
is one way to make the receiving cell look blank if A1 is empty)

 

[Bob Phillips]

M1: -3
N1: =+M1

N1 contains -3, not +3 as you suggest

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

summary:

if source is text or numeric, show the value as is
if source is blank, show ZERO
if source is error, show error

Thanks to all for your time.

 

[Bob Phillips]

=IF(A1="",0,A1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

summary:

if source is text or numeric, show the value as is
if source is blank, show ZERO
if source is error, show error

Thanks to all for your time.

 

[Stan Brown]

Thu, 9 Aug 2007 05:06:03 -0700 from Tim

Turns any number to positive

No, it does not.

=+celladdress is *precisely* the same as =celladdress.




=abs(celladdress) turns a negative or positive number to positive.