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
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks