Excel Data Tables - Easy What-if Analysis for Multiple Variables - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 6
Luis
i need help on making a chart on excel. never used excell before so im new at this. Lets say theres 4 soccer games, and the options are Over/Under in goals for each game, my formula :would be 2(options: Over or Under) - 4(games), I'll get 16 different probabilities. All games going over is one probability out of 16, first game over, other three games under, thats another probability out of 16. How can I lay the all out, lets say if i want to do 10 games instead(2-10=1024 different probabilities)
reply
i need help on making a chart on excel. never used excell before so im new at this. Lets say theres 4 soccer games, and the options are Over/Under in goals for each game, my formula :would be 2(options: Over or Under) - 4(games), I'll get 16 different probabilities. All games going over is one probability out of 16, first game over, other three games under, thats another probability out of 16. How can I lay the all out, lets say if i want to do 10 games instead(2-10=1024 different probabilities)
reply
taube551
Hey, I try to this with but I dont want to use hard numbers in colum and rows...But the output of the table has than wrong numbers.. is this just not possible or whats the reason for it? Also when I changed the number in the top left corner in the system the data table doesnt update by itself and even if I press F9 or try to refresh the data it doent work (also I checked in Options that Refreshment for data table is on).. do you know the mistake? Thanks in advance!!
reply
Hey, I try to this with but I dont want to use hard numbers in colum and rows...But the output of the table has than wrong numbers.. is this just not possible or whats the reason for it? Also when I changed the number in the top left corner in the system the data table doesnt update by itself and even if I press F9 or try to refresh the data it doent work (also I checked in Options that Refreshment for data table is on).. do you know the mistake? Thanks in advance!!
reply
Thrushen
Thank You for this, I have two comments. One is that the formula outputs, the formula inputs, and the data table need to be on the same sheet. Else the data table does not function. That is you have to reference cells on the same sheet. My second issue is that my data tables do not seem to be working correctly and I cannot find the fault, any ideas on how to troubleshoot?
reply
Thank You for this, I have two comments. One is that the formula outputs, the formula inputs, and the data table need to be on the same sheet. Else the data table does not function. That is you have to reference cells on the same sheet. My second issue is that my data tables do not seem to be working correctly and I cannot find the fault, any ideas on how to troubleshoot?
reply
Saurabh
Again, for understanding this concept I chose ur chnl. I've not found this kind of explaining style in which I make myself clear promptly, in any another chnl.
reply
Again, for understanding this concept I chose ur chnl. I've not found this kind of explaining style in which I make myself clear promptly, in any another chnl.
reply
Rasoul
Now I understand the meaning of Data Table in What-if analysis. It was there for so long time and I didn't know what does it mean? Thanks
reply
Now I understand the meaning of Data Table in What-if analysis. It was there for so long time and I didn't know what does it mean? Thanks
reply
Ivan
Hi, great little video. I was wondering, on the pizzas calculation, how did you do the vertical label -Pizzas per Month-? Text box?
reply
Hi, great little video. I was wondering, on the pizzas calculation, how did you do the vertical label -Pizzas per Month-? Text box?
reply
Add a review, comment
Other channel videos
