Here advance use of Micrsoft Excel described using vba. To demonstrate the use a real life example as mentioned below considered for programming. Screen shot of Excel file and Vba program is as shown belo. Site visitor may download the respective excel file for better understanding about how to use named ranges and vba programming
By Simulation we have observed probability as 2.80% (aprx.). Try for checking the correctness of the simulation by deriving this probability mathematically.