So i have this small problem.
lest say i have field a-b and c
I am trying to get growth. The only one that works is if there is data in both. if both values is 0 i need o
a b c 0 0 #DIV/0! 0 10 1 10 0 -10 12 6 .5
if first value has data and second value has 0 then it should be -100
if first value has no data but second hone has data then it should be 100
at this moment the code is
Please Login or Register to view this content.
What if both have values?I am trying to get growth. The only one that works is if there is data in both. if both values is 0 i need o
if first value has data and second value has 0 then it should be -100
if first value has no data but second hone has data then it should be 100
=IF(AND(A2=0,B2=0),0, IF(AND(A2>0,B2=0),-100,IF(AND(A2=0,B2>0),100,"Both have values")))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
if both has values it should be (d-c)/c
where did D column come from ?
ok -d is my live excell (b-a)/a
the code in my macro is
Please Login or Register to view this content.
not doing via a macro sorry , missed that forum
using a function
=IF(AND(A2=0,B2=0),0, IF(AND(A2>0,B2=0),-100,IF(AND(A2=0,B2>0),100,(B2-A2)/A2)))
IF(AND(RC[-2]=0,RC[-3]=0),0,IF(AND(RC[-2]>0,RC[-3]=0),-100,IF(AND(RC[-2]=0,RC[-3]>0),100,IF(AND(RC[-2]>0,RC[-3]>0),(RC[-2]-RC[-3])/RC[-2]))))
Here is the full code, thanks would not have gotten it right without your help
glad that worked ok for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks