![]() I've done it very inelegantly using a formula on another sheet copied down (A1 takes the percentage off the original value, A2 takes the percentage from the value of A1 etc. But then that won't really help, as I'm trying to do this entirely in excel. I'm certain I could do this in other languages. I'm also sure that this is actually quite an easy script (though I don't know VBA at all, so it wouldn't so easy for me to do). Now perform the Iterative option in Excel. Click Formula and tick the checkbox enable iterative calculations and click OK. Like I said, I'm almost certain this cannot be done outside of scripting (VBA etc.), since to my knowledge excel formulas can't loop and count? The Enable Iterative calculations option allows us to do so. I'm trying to work out how many times the formula must run to get the values to 0 I am at the very beginning and very new to Lambda Functions in Excel (but I have the basics). If there is an error, I want it to build a new 12 x 6 range within the function and then check that for errors. I'm then going to repeat (so reduce the new values by another 20%) until the answer is zero (rounded to 2dp in this example, though I may need more or less rounding later). So, I am working on another issue and need to check a 12 x 6 excel range for errors. The simplest way to explain it is to say I'm going to reduce each number by the percentage given in cell A1 (20% in my example). So I have a table that looks like this A B C D E This number is actually a percentage (lets call it 20% in this example) I've also got another cell somewhere (lets just say that this cell is A1 for my example), which has another number in it. I'm almost certain the answer is 'no', but I thought I'd ask the people here just in case there is some magic formula I haven't yet found.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |