is this possible??

[johnnyd98]

I need some kind of formula that tells me: which number, within a given range, divides into a list of other numbers evenly within exactly 2 decimal places.......Any ideas?


Thanks!!

 

[shg]

Welcome to the board.

For example, ...?

 

[johnnyd98]

thanks for the welcoming, I'm glad to have found this forum.

Here is more detail on my problem. I am trying to determine the price of a widget when all I have to go by are previous gross sales totals for the item.

For example, below are four different invoice totals for one widget:

41.03
26.11
29.84
18.65

Let's say I have some market background on this widget, and assume that it would sell somewhere between $3.00 to $4.50. I want to know which number between my given range divides evenly into the above four numbers.

In this case, the number is $3.73. I have many of these to figure out and if I could automate this process somehow I could save a ton of time!

Thanks!

 

[shg]

=GCD(ROUND(100*A1:A4, 0))

The formula MUST be confirmed with Ctrl+Shift+Enter.

 

[johnnyd98]

awesome thanx shg