LinkBack URL
About LinkBacks
Im trying to turn the following calculator into using 4 selections but i cant extend the array? any help appreciated
Im trying to turn the following calculator into using 4 selections but i cant extend the array? any help appreciated
Last edited by port; 07-21-2014 at 04:55 AM.
My antivirus program considers that download site dangerous. Why don't you just post the workbook in the thread? Hit the Go Advanced button and the Manage attachements.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Never use Merged Cells in Excel
OK i think that worked Dutching - Variable Profit.xlsx
Thanks for letting me know Jacc I have deleted it and uploaded the file.
- Select K7:N10
- Click in the formula bar. A blue rectangle should now appear around G7:I9
- Grab the lower right corner of that rectangle and stretch it out to G7:J10
- Hit Ctrl + Shift + Enter
great!!! thats so close but I am still having trouble in the coloured box to get the 4 selections
sorry not the selection the stake amount. It calculates the stake amount needed after entering into C10 then D10
Ah ive cracked it! thanks so much for your help Jacc
No its not working
Post your non-working version and I'll have a look.
E10 is the same as E7 Dutching - Variable Profit.xlsx
- Select E7:E10
- Hit F2 button
- Finish with Ctrl + Shift + Enter
Sweet thanks heaps mate
Glad to hear it works!
Don't forget to mark the thread SOLVED (under Thread Tools at the top of this page).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks