B Bob Phillips Aug 9, 2007 #3 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)
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)
D Dave Peterson Aug 9, 2007 #4 =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)
=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)
B Bob Phillips Aug 9, 2007 #5 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)
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)
G Guest Aug 9, 2007 #6 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.
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.
B Bob Phillips Aug 9, 2007 #7 =IF(A1="",0,A1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) yu said: 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. Click to expand...
=IF(A1="",0,A1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) yu said: 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. Click to expand...
S Stan Brown Aug 10, 2007 #8 Thu, 9 Aug 2007 05:06:03 -0700 from Tim Turns any number to positive Click to expand... No, it does not. =+celladdress is *precisely* the same as =celladdress. =abs(celladdress) turns a negative or positive number to positive.
Thu, 9 Aug 2007 05:06:03 -0700 from Tim Turns any number to positive Click to expand... No, it does not. =+celladdress is *precisely* the same as =celladdress. =abs(celladdress) turns a negative or positive number to positive.
