I'm trying to generate some numbers using Excel but am having major diffculty because (1) I'm just not good with Excel, and (2) the math is a bit complex.

Here's a sample of my current setup. I enter my base entries and then use the column of $5 intervals to run a calculation to generate a number on the far right that's fairly close to a significant number and round it off (as illustrated.) My current setup doesn't allow for three or four entries (which, I eventually would like) and it doesn't limit the output to just near significant numbers. As near as possible, I need to maintain the ratio between my base entries. And I'm most interested in generating new numbers that are very close to multiples of $5.


$35.71 and $62.39 (base entries)

$5 /35.71 =0.140016802 *62.39 =$8.736
$10 /35.71 =0.280033604 *62.39 =$17.471
$15 /35.71 =0.420050406 *62.39 =$26.207
$20 /35.71 =0.560067208 *62.39 =$34.943 roundup to $35
$25 /35.71 =0.70008401 *62.39 =$43.678
$30 /35.71 =0.840100812 *62.39 =$52.414
$35 /35.71 =0.980117614 *62.39 =$61.150
$40 /35.71 =1.120134416 *62.39 =$69.885 roundup to $70
$45 /35.71 =1.260151218 *62.39 =$78.621
$50 /35.71 =1.40016802 *62.39 =$87.356
$55 /35.71 =1.540184822 *62.39 =$96.092
$60 /35.71 =1.680201624 *62.39 =$104.828 roundup to $105
$65 /35.71 =1.820218426 *62.39 =$113.563
$70 /35.71 =1.960235228 *62.39 =$122.299
$75 /35.71 =2.10025203 *62.39 =$131.035
$80 /35.71 =2.240268832 *62.39 =$139.770 roundup to $140


Any Excel eggheads out there who just eat this stuff up and would like to help? I'd really appreciate it. (I can email my current xls spreadsheet if it would be helpful.)