Thank you so much Bob, it works, you are the best!
"Bob Phillips" wrote:
Perhaps
=ROUND(ROUNDUP(R14/L14,2)*L24,0)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"MO" wrote in message
...
I'm trying to get the following result ($680,994) and no matter what
formula
I use, I get the incorrect answer ($676,610). I think the problem is with
L14 but cannot figure it out, can you help?
Here is one of the formula's I have tried using
=R14/FIXED(L14)*L24
R14=$2,586,542
L14=$2,683,818
L24=($702,056)
--
Thank you for you help
MO
Albany, NY
|