Recent content by mrdane

That sounds great! Thank you. I sent you my email address, you'll have to tell me if you don't receive it. Thanks again!

Here's a sample of my current setup. I then find a number on the far right that's fairly close to a significant number and round it off (as illustrated.) It doesn't provide for three or four entries (I also need to be able to change the dollar amounts of me entry numbers) and it doesn't limit...

The multiple of 5 is important because I'm looking for round-looking dollar amounts; like $25, $75, $255, $300, $350 and whatnot. The math is important because on this financial transaction the profit margin is so very slim (the profit percentage works out to be 100 minus the sum of my two -or...

Well, I've put together a very elementary (crude even) spreadsheet that sort of does what I'd like to do. Yeah, the math has my head spinning. I can send you the spreadsheet I cobbled together if you're willing to take a look-see of what I'm looking for.

OK, I've got some more time here to take a crack at this and, at this point, I'm still not much closer to a solution. I guess one way to look at it is, I need a a single multiple applicable to both numbers the result of which can be evenly divided by 5.

I'm afraid this is going to be UGLY then... 'cause I'm not familiar with the IF function in Excel. I appreciate your help, and I think I can find out how to use IF on my own by using Excel Help or searching on the Excel Help Forum. I found this to round to the nearest 5 (=ROUND(D4/5,0)*5)...

Anyone? Anyone? I guess what I'm really looking for is how to figure out a common multiplier to get both of my figures up to a round number. BTW, these are dollars amounts (i.e. $62.89 and $35.71) and I'm trying to get them to round amounts for sake of simplicity.

Thanks for the reply but I think I didn't ask my question very well. I also posted this same problem on an Excel Help Forum I found online with this wording: I have a set of integers that I need to maintain the ratio between them while rounding to the nearest 5. For example; 62.89 plus...

Hopefully somebody here can clue me into figuring out a math problem. I'd like to create an Excel spreadsheet that will allow me to enter my numbers and have it calculate the results, but I'm not sure how to do the calculation (or for that matter, perhaps how to enter it into Excel...) So...