I need to do the following formula, but it isn't working for me
(n1-n2)/n2*100
what is happening, is n1-n2 then it is dividing by the product of n2*100
I need it to do n1-n2, then divide by n2, then multiply by 100
I need to do the following formula, but it isn't working for me
(n1-n2)/n2*100
what is happening, is n1-n2 then it is dividing by the product of n2*100
I need it to do n1-n2, then divide by n2, then multiply by 100
like this?
=((N1-N2)/N2)*100
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
I did, when I hit enter, the second set of grouping ()'s disappear... its like it auto corrects or something
Works for me. With 1 and 2 in N1 and N2 respectively, I get -50
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks