Formula for calculating value of each selling coin of 5 shirts which average selling is 17coin the values have to be between 1 to 3
I tried this =Randarray(5,1,1,3)/sum(randarray(5,1,1,3)*17)
You choose Excel Challenges for Your posting - it is okay, if ... as written ... Post an Excel related Challenge for others to Solve (You must have a solution) Don't post questions here!
Do Your try work?
... or is this basic question?