Hello, I intend to make is this: In cell B7 would be reflected the amount deposited in a gambling game card, which would be distributed automatically in amounts of 10.00 for cells D3: AB3 (amount to play twice a week ), starting to show 0 when less than 10 without presenting circular references.
Best regards
Jonnas
Exemple.xlsx
Last edited by Jonnas123; 01-10-2016 at 06:28 PM. Reason: Better explanation
Welcome to the forum.
Your title is really vague and you should fix this to make it more clear what you are really asking.
I think that this is what you are looking for in E4 to be filled across (this is just a guess on my part)
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank did not work, what I want is attached file.
This filled across will not display an error. If this isn't it, I have no idea what you are trying to do.
Enter in D3 and fill across.
Formula:Please Login or Register to view this content.
What are you trying to do in B7?
=SUM(B3:B6)-(D3:AB3) evaluates to an error because (D3:AB3) doesn't mean anything.
You mention a loop in your first post - did you try something else which gave you a 'circular error' warning?
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
I'll leave this for someone else. This doesn't make sense to me.
Jonnas welcome to the forum
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(note: this change is not optional)
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
Also, in your file, you have a column with a few values and an error, and a row with a bunch of errors - that in now way (that I can see) explains what you are trying to do. AFTER you have fixed your title, can you explain, in words, what you want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks