Mar 07 2022 05:03 AM
I used to be able to count up the sum of two dices using this: =HVIS(B$18=1;HVIS(D$5=E5;1+F5;F5);0)
D5 beeing the sum of two dices and B18 beeing a "zerobutton" with the values 0 and 1.
When used now I don't get any counts???
Please help!
Mar 07 2022 05:05 AM
Please attach a small sample workbook demonstrating the problem.
Mar 07 2022 05:11 AM
Mar 07 2022 05:15 AM
If you can't upload, you might use OneDrive, Google Drive, Dropbox or similar to share a sample workbook and paste a link into a reply here.
Mar 07 2022 05:18 AM
Mar 07 2022 05:45 AM
@Fchri1972 Allow for iterative calculation as shown in the picture below. file, Options, Formulas (don't know the Danish menu items names, sorry!). Allow for a maximum of 1 iteration and your graph will grow one throw at the time by pressing F9.
Mar 07 2022 05:48 AM
Mar 07 2022 05:55 AM - edited Mar 07 2022 05:55 AM
Thanks! You cannot do this with formulas, since it causes circular references: the formula in F5 refers to F5 etc.
You need a bit of VBA code for that. See he attached version; you'll have to allow macros when you open it.