larry12445
New Member
- Joined
- Jan 17, 2005
- Messages
- 16
I'm having the following issue.
Cell V6 shows a display of "15.4" and has the following formula:
=DOLLARFR(DOLLARDE(60,5)-DOLLARDE(O6,5),5)
Cell W6 shows a display of "17.1" and has the following formula:
=DOLLARFR(DOLLARDE(P6,5)-DOLLARDE(100,5),5)
When I combine these two cells with the following formula in cell X6 I get "32.5"
=DOLLARFR(DOLLARDE(V6,5)+DOLLARDE(W6,5),5)
However, if I manually enter the values in W6 "15.4" and W8 "17.1" and put the following formulat in X8 I get "33.0" as I would expect.
=DOLLARFR(DOLLARDE(V8,5)+DOLLARDE(W8,5),5)
Why am I getting "32.5" instead of "33.0" in cell X6 and how can I fix this?
Any suggestions, ideas, etc. are appreciated.
Thanks,
Larry
Cell V6 shows a display of "15.4" and has the following formula:
=DOLLARFR(DOLLARDE(60,5)-DOLLARDE(O6,5),5)
Cell W6 shows a display of "17.1" and has the following formula:
=DOLLARFR(DOLLARDE(P6,5)-DOLLARDE(100,5),5)
When I combine these two cells with the following formula in cell X6 I get "32.5"
=DOLLARFR(DOLLARDE(V6,5)+DOLLARDE(W6,5),5)
However, if I manually enter the values in W6 "15.4" and W8 "17.1" and put the following formulat in X8 I get "33.0" as I would expect.
=DOLLARFR(DOLLARDE(V8,5)+DOLLARDE(W8,5),5)
Why am I getting "32.5" instead of "33.0" in cell X6 and how can I fix this?
Any suggestions, ideas, etc. are appreciated.
Thanks,
Larry