Hello Everyone,
I have been struggling with this for a while.
I wish to be able to enter a value in a cell and then the adjoining cells will increase or decrease by a given increment. But the cell I enter the value into will be random. Not always the same one.
What will the formula be?
Please see attachment for a clearer picture.
Hope you can help.
Ignatius58
Check attached
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Ok I have reduced the formula size
You can use this one in A2 and copy across till H2
=IFERROR(10-(MATCH(10,$A$1:$H$1,0)-COLUMN()),"")
I have placed the amount in column B and the increment in column A and range is C to H so why does this not work?:
=IFERROR(B-(MATCH(B,$C$A:$H$A,0)-COLUMN()),’’’’)
Havnt looked at the file or anything, but unless B is a range name, you need to include a row number with that, for it to be a cell reference?
For example...
=IFERROR(B1-(MATCH(B1,$C$A:$H$A,0)-COLUMN()),’’’’)
Also, that last part...,’’’’)...those dont look right either, they need to be 2 " ...the quotation marks on the key to the left of the enter key " "
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Ford,
Many thanks for your help.
Please may I ask you to look at the attachment so you can see what I am trying to do?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks