This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Assume array [5000,1000,500,100,50]. and reference value as =
18345expected value should be = (5000*3)+(1000*3)+(100*3) = 18300.so the
nearest value should be 18300.he wants a formula to do this job.