Excel Division that returns the whole number

[Sbugle]

Hi,
I need to create a calculator that returns 2 numbers, but must be to an exact 2 decimal places.
For example, we have a figure of 1,759.06 and need to know what the closest divisible number with 2 decimal points is that returns a result less than 104.45.

X*Y = 1759.06
X needs to be less than 12, 24 or 36.
Y needs to be less than 104.45 and exact to 2 decimal places.

 

[Anonymous1378]

Perhaps try

=LET(
_XY,1759.06*10000,
_X,36*100,
_Y,104.45*100,
_A,FILTER(SEQUENCE(_X),MOD(_XY,SEQUENCE(_X))=0),
_B,FILTER(_A,(_A<_X)*(_XY/_A<_Y)),
"X:"&TEXT(_B/100,"0.00")&"  Y:"&TEXT(_XY/_B/100,"0.00"))

 

[Sbugle]

Thank you So

Perhaps try

=LET(
_XY,1759.06*10000,
_X,36*100,
_Y,104.45*100,
_A,FILTER(SEQUENCE(_X),MOD(_XY,SEQUENCE(_X))=0),
_B,FILTER(_A,(_A<_X)*(_XY/_A<_Y)),
"X:"&TEXT(_B/100,"0.00")&"  Y:"&TEXT(_XY/_B/100,"0.00"))

Thank you so much. I need X to be a whole number. I have tried to set it up in my excel where 1759.06 and 36 are cell links so that we can input this information and then the calculation is done. 36 could be any number between 1-36. so if the whole number X is multiplied by Y you get the exact 1759.06 or whatever is in this cell.

 

[Sbugle]

Thank you So

Thank you so much. I need X to be a whole number. I have tried to set it up in my excel where 1759.06 and 36 are cell links so that we can input this information and then the calculation is done. 36 could be any number between 1-36. so if the whole number X is multiplied by Y you get the exact 1759.06 or whatever is in this cell.

=LET(_XY,C4*10000,_X,C5*100,_Y,C6*100,_A,FILTER(SEQUENCE(_X),MOD(_XY,SEQUENCE(_X))=0),_B,FILTER(_A,(_A<_X)*(_XY/_A<_Y)),"X:"&TEXT(_B/100,"0.00")&"Y:"&TEXT(_XY/_B/100,"0.00"))

 

[Anonymous1378]

There isn't a solution where X is a whole number and Y is a 2 decimal number less than 104.45. It's just mathematically impossible. The closest in terms of decimal places is X = 20 and Y = 87.953