Finding a number with 2 decimal places

[shah0101]

Hi Experts,

I have a value in C10 (say 37,313.58) which is fixed.

In B10 & B11 are Prices which can be changed
In A10 is A11 Quantity which can be changed

I need a formula / vba script to get exact two decimal place number (not rounded, not truncated) in:
(1) "B10" (range from 0.84 to 6.00) wholly divisible by "C10" by "A10"
(2) "B11" (range from 12.00 to 30.00) wholly divisible by "C11 by A11"


How we can find an exact two decimal places number by automatically change the number either in B10/B11 or A10/A11 to get the final number as in C10 (which is basically A10 * B10 or A11 * B11).


I don't know if I am making any sense! so uploaded a picture.

 

[footoo]

Assuming the quantity is a whole number, it is not possible with data you provided without rounding.
$37,313.58 divided by 0.84 to 6.00 in increments of 0.01 does not produce any whole numbers.
Neither does 12.00 to 30.00.

 

[shah0101]

Assuming the quantity is a whole number, it is not possible with data you provided without rounding.
$37,313.58 divided by 0.84 to 6.00 in increments of 0.01 does not produce any whole numbers.
Neither does 12.00 to 30.00.

WE CAN CHANGE BOTH THE QUANTITY (IN INTEGER) AND PRICE (WITH TWO DECIMAL PLACES) TO BRING THE VALUE. ANY IDEAS PLEASE?

 

[Gerald Higgins]

Can you give a simple example of what exactly you want to do, please ?

 

[bebo021999]

I have tested manually, but no results.
Copy down to price = 6. No "TRUE" return in column C

Book3
	A	B	C
9	Qty	Price	Value
10			37,313.58
11
12
13
14	44,420.93	0.84	FALSE
15	43,898.33	0.85	FALSE
16	43,387.88	0.86	FALSE
17	42,889.17	0.87	FALSE
18	42,401.80	0.88	FALSE
19	41,925.37	0.89	FALSE
Sheet3

Cell Formulas
Range	Formula
A14:A19	A14	=$C$10/B14
C14:C19	C14	=INT(A14)=A14
B15:B19	B15	=B14+0.01

 

[shah0101]

Can you give a simple example of what exactly you want to do, please ?

Actually, I just get the total invoice value and from that value I need to get the price (upto to decimal place) as mentioned above in the range. Quantity doesn't matter but it has to be an integer number without any decimals.

 

[Gerald Higgins]

Same question again.
Can you give a simple example of what exactly you want to do, please ?
Give us the input values, and the desired result please.

 

[footoo]

I have tested manually, but no results.
Copy down to price = 6. No "TRUE" return in column C

I already advised that to the OP in post #2. He does not seem to understand.

 

[shah0101]

I already advised that to the OP in post #2. He does not seem to understand.

Yes, you are right, I may be a bit vague or inaccurate in explaining my self.

Please see the image below. On row 224 I found a number with two decimal places in both price and quantity which is okay with me. This I got by copying and pasting hundreds of lines by increasing the price by 0.01 in each row. This is what I want in a single formula that I put in the value and Price and Quantity can comes up itself with an integer without decimal place OR maximum with two decimal places.

Please guide / advise.

 

[bebo021999]

On row 224 I found a number with two decimal places in both price and quantity which is okay with me. This I got by copying and pasting hundreds of lines by increasing the price by 0.01 in each row. This is what I want in a single formula that I put in the value and Price and Quantity can comes up itself with an integer without decimal place OR maximum with two decimal places.

So Quantity could be whole number or 1- 2 decimal?
Is it:
1st priority: whole number
2nd: from 1 to 2 decimal
?