FIXED formula problem
 

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

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

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