Hello everyone,
I have made the following table:
A2 = 10 000 B2 = 50% C2 = A2/(A2*B2) = 2
So, if I change B2 to 25%, C2 changes to 4.
This is all very fine, but I was wondering if it is possible to link the cells B2 and C2 in such a way that if I now would enter the value 5 in C2 I would get the corresponding value of 20% in B2.
Is this possible at all or is there another solution? Perhaps adding one extra cell?
My life does not depend on this, but it would be very cool if this is possible.
Thanks very much in advance. I`ve been scratching my head on this one for a while
Elijah
Bookmarks