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



Posted by Aladin Akyurek on September 09, 2001 9:03 AM

What is the formula that you use to compute a person's age?