MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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&LT;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?