Hi Walter, *=(A1-B1)/ABS(B1)* should do the trick. tc
________________________________ From: Walter Hildebrandt <[email protected]> To: Users Group <[email protected]> Sent: Friday, April 17, 2009 11:54:01 AM Subject: [users] mixed positive and negative numbers Putting *=(A1-B1)/B1* in C1 sometimes gives the wrong answer in C1 when positive and negative numbers are involved. For these example cells A1 and B2 are formatted to dollars and C1 is formatted to percent. When A1 is $10 and B1 is $5 C1 is 100% which is correct When A1 is -$10 and B1 is $5 C1 is -300% which is correct When A1 is $10 and B1 is -$5 C1 is -300% which is not correct. 300% would be the correct in C1 When A1 is -$10 and B1 is -$5 C1 is 100% which is not correct -100% would be correct in C1 What formula can be used in C1 to get the correct answer __________________________________________________________________ Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail. Click on Options in Mail and switch to New Mail today or register for free at http://mail.yahoo.ca
