S sambit Member Mar 19, 2015 #1 Hi, I have 3 Coloums having number range between 0 to 15. it must be randbetween(0,15) but the sum of 3 coloums should be 18. The number 18 is fix. please help to solve the issue. Attachments Test.xlsx Test.xlsx 8.6 KB · Views: 9
Hi, I have 3 Coloums having number range between 0 to 15. it must be randbetween(0,15) but the sum of 3 coloums should be 18. The number 18 is fix. please help to solve the issue.
Somendra Misra Excel Ninja Mar 19, 2015 #2 Hi Sambit, See this file, here third no is getting negative also some time. Regards, Attachments Test (26).xlsx Test (26).xlsx 9.1 KB · Views: 3
S sambit Member Mar 19, 2015 #3 Somendra Sir, Thanks for response. is it possible without negative number ?
N NARAYANK991 Excel Ninja Mar 19, 2015 #4 Hi Sambit , See this file. Narayan Attachments Test.xlsx Test.xlsx 9.2 KB · Views: 5
S sambit Member Mar 19, 2015 #6 Narayan Sir, please help to solve the following case i.e, one more coloum insert say D, and randbetween 0,8 and Total Sum should be 19. Attachments TEST.xlsx TEST.xlsx 9 KB · Views: 3
Narayan Sir, please help to solve the following case i.e, one more coloum insert say D, and randbetween 0,8 and Total Sum should be 19.
N NARAYANK991 Excel Ninja Mar 19, 2015 #7 Hi Sambit , I think this works , but please check thoroughly. Narayan Attachments TEST (1).xlsx TEST (1).xlsx 8.6 KB · Views: 5