Division of currency formula with/without rounding

[Corinne30]

Need formula for:
User has an interest amount of 17.35 which needs to be divided by 2 which is a result set of 8.675.
Once that division is done I need to have the 2 amounts 1 should be 8.68 and the other should be 8.67 which when added together total back to 17.35
How should a formula for this be written so that the rounding is accurate?

 

[dgillz]

Please share your current formulas.

 

[SkipVought]

Hi,

Welcome to the New Tek-Tips.

If your value is in A1, the expression below in the Formula Bar gives you one values in B1 and the other value in C1.
Row 2 shows the FormulaText in columns B & C.
Rows 3-6 show the progression of the formula calculation in column B

Hope that helps.

EDIT: Didn't notice this is Crystal Reports. Sorry. Thought I was in a different Forum for Excel.

 

[Corinne30]

I was hoping to see something in a Crystal reports formula

 

[Corinne30]

Please share your current formulas.

Currently my formula is :
{?interest}/2 which results in 8.675

 

[Corinne30]

Hi,

Welcome to the New Tek-Tips.

If your value is in A1, the expression below in the Formula Bar gives you one values in B1 and the other value in C1.
Row 2 shows the FormulaText in columns B & C.
Rows 3-6 show the progression of the formula calculation in column B

Hope that helps.

EDIT: Didn't notice this is Crystal Reports. Sorry. Thought I was in a different Forum for Excel.
View attachment 18

 

[Corinne30]

Any help is appreciated.

 

[dgillz]

I meant to post your formulas that return the 2 dollar amounts, not the interest rate. Please try again.