LinkBack URL
About LinkBacks
Is it possible to link a spinner to 2 cells?
if so how, and thanks x x
Is it possible to link a spinner to 2 cells?
if so how
Hi,
Try this link for more info
http://cws.internet.com/article/1863-.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thank you for replying but im not very good at making my own formula's really!
basically i have a stock level cell that the spinner is linked to (B8)
Then in another cell (O18) i want it to tell me how much the stock level has increased by. I was thinking that if i reset O18 to zero each time then this would be possible.
Please reply someone, or if you think you can help me but dont really understand then still reply and i will expain it more
Hello there,
I’m trying to understand exactly what you are trying to achieve, but it would be better if you could provide a small zipped sample of your data together with the expected result, then I’m sure it will be easier for me (or someone else) to help you.
To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.
Yep, sorry, it was a bit confusing what i said lol.
This is just my prototype by the way, not my finished thing, its for my i.t project.
Anyway. If you go to stock levels page you will see to the left there is a little area i will be using for calculating. In the quanitity collumn i would like it to go from zero and increase by however many times the spinner is clicked that corresponds to that item. Sorry im even confusing my self. I will try and explain it on the spread sheet then attach it.
thanks. Oh an if this cant be done can anyone provide an alternative
Try in O18
=B8
nope because that just gives me the value of b8 but say if on the 5th of october the value was 3 and then the user went back on the 20th october and increased it to 10 then i want the quantitiy to display 7. So i want the value in o18 to be however many it increased by.
ok it's alrite i'e found a way around it....as long as i can find a forumla that can do this....
i need to find the difference between two numbers, i know i could just subtract but sometimes the number thats being taken away will be bigger than the other number, sometimes it will be smaller, e.g sometimes it will be
9-7 but others it could be 7-9 soo....any help please
either that or is there anyway to take the '-' off of for example '-2' ?
Something like this,
=IF(B1-A1<=0,0,B1-A1)
hmm nope that didnt seem to work, prehaps if you could like take that formula step by step then i could try and tweek it a bit. And also its A2 and A3 that i want to use as my values
oh and also i will be like adding rows but i want the formula to stay applied to a2 and a3, not to change when i add rows
Last edited by xlizix; 11-20-2007 at 01:52 PM.
yayayayayy i worked out the formula, its, =IF(A3-A2>0,A3-A2,A2-A3)
yay!
thank you for all your help:D:D if you could just help me with one more thing ...(for now:P) how would i make it apply to a2 and a3 even when the cells are shifted down, because when i do shift them down the formula then applies to a3 and a4.
thanks lizi x
Yes your IF formula should do the trick, but you can also use the ABS formula. This does exactly what you ask for : Removes the '-' from all negative numbers.
=ABS(A3-A2)
You want the references to A3 and A2 to stay the same even if you move the content of A3 and A2 ? Then use INDIRECT.
=ABS(INDIRECT("A3")-INDIRECT("A2"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks