formula for negative numbers
Posted by George on September 09, 2001 7:00 AM
I have a column of negative and positive number that reflect a person's age (20, -40, 45, -60). The positive number are OK but the negative numbers reflect the person's age correctly if you add a positive 100 to the negative number in the cell; example: a -40 would really be 60, a -60 would really be a 40. Yet in this column I do not want it to affect the positve numbers which are correct... I just need the negative numbers changed as indicated above. The column is rather long.. about 3000+ cells. Thanks for any advice!!!! GEORGE
Posted by . on September 09, 2001 7:13 AM
=IF(A1<0,A1+100,A1)
=IF(A1<0,A1+100,A1)
Posted by Aladin Akyurek on September 09, 2001 9:03 AM
What is the formula that you use to compute a person's age?
