% variance

A

Abdul

Hi All,


How can I have a formula to get % variance (+/-) without
generating an error?

for eg: if A1=100 and B1=150 then I shud get in C1 50%
and if A1=150 and b1=100 then I shud get in C1
(33.33%)

i am having this with the formula (B1/A1)-1 IN C1

Now my problem is that both A1 and C1 can be zero, either
of them or both of them can be negative, one can be
negative and the other positive, a1<b1, a1>b1 with
negative values etc. Taking all the possiblities how can
I have a working formula??!!!

Thanks for your help.

Abdul
 
A

Abdul

it wont work if both having minus figures..

i think u did'nt read my complete message..
i have that, but want to know all the possibilities
incorporated..

thanks
 
D

Dick Kusleika

Abdul

It works for me without any errors. What do you want the results to be for
these numbers

100 150
-100 150
100 -150
-100 -150
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

% Variance 5
Repost: % Variance 2
Time Calculations Help 4
help with formula 1
Putting Formula in all cells give Circular Reference. Please help 7
Excel Formula and Variance Analysis 0
Re. Conditional formating of adjacent cells but down a column 0
VBA to create new data help please 2

Top