counting in 32 nds

[jpdamigaman]

Hi how would I program a spread sheet to count bond prices

bonds are in 32 nds

say bond price is 131.00 ,131.01 131.02 until 131.31 then it goes to 132.00 132.01 132.02 etc

I want to add 6 to 131.31 and get 132.05 not 131.36 in decimal

[DonkeyOte]

Given use of XL2011 one possibility

Please Login or Register  to view this content.

where A1 holds 131.31 and B1 holds 0.06

[jpdamigaman]

HI That worked great!

Thanks

I was wondering how to subtract B cell form A as well in a seperate calculation?

[DonkeyOte]

One possibility:

Please Login or Register  to view this content.

I'm sure with more thought it could be improved upon.

edit: alternative

Please Login or Register  to view this content.

[shg]

Late to the party, but not just ...

=DOLLARFR(DOLLARDE(A1, 32) - DOLLARDE(B1, 32), 32)

?

Please Login or Register  to view this content.

[DonkeyOte]

yeah I guess you could use that.... ... time for me to sign off now I think !

edit: if nothing else at least the extended subtraction version is non ATP reliant ... where did I put those straws...

[shg]

I'm surprised those functions were not made array-compatible when they made the ATP go away in Excel 2007+.

[jpdamigaman]

hi got wrong numbers in this formula

=DOLLARFR(ROUND(DOLLARDE(SUM(A6;B6);32);15);32)
130.16 + 0.16 130.32 wrong should be 131.00

=DOLLARFR(DOLLARDE(A11;32)-DOLLARDE(B11;32);32)
130.14 - 0.16 129.3 should be 129.29

see pic

[shg]

If you want help with pictures, post pictures,

If you want help with Excel, ...

[DonkeyOte]

=DOLLARFR(ROUND(DOLLARDE(SUM(A6;B6);32);15);32)
130.16 + 0.16 130.32 wrong should be 131.00

The same generates 1301.00 for me - are the values in A6:B6 the result of formulae - if so are each rounded to 2 decimals ?

=DOLLARFR(DOLLARDE(A11;32)-DOLLARDE(B11;32);32)
130.14 - 0.16 129.3 should be 129.29

By my reckoning 129.30 is the correct result... 130.13 -> 129.30 is 16 data points inclusive [130.00 being a data point in it's own right]

As shg says - if you want to post examples do so with a file.

[jpdamigaman]

Hi I'm running this open office and it wrong but excel is correct!

can't see whats wrong with open office