What formula do I use to show a negative percentage. Example: Column 1 column 2 column 3 0 5 -%
M Michelle Dean via OfficeKB.com Aug 2, 2005 #1 What formula do I use to show a negative percentage. Example: Column 1 column 2 column 3 0 5 -%
B bj Aug 2, 2005 #2 if what you want is what percent of column 2 is column 1 =A1/B1 and format column 3 as percent If one is a negative the result will be negative I think what you want is more complex than this but we need more information
if what you want is what percent of column 2 is column 1 =A1/B1 and format column 3 as percent If one is a negative the result will be negative I think what you want is more complex than this but we need more information
