FIXED formula problem

[MO]

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)

 

[Bob Phillips]

Perhaps

=ROUND(ROUNDUP(R14/L14,2)*L24,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[MO]

Thank you so much Bob, it works, you are the best!

Perhaps

=ROUND(ROUNDUP(R14/L14,2)*L24,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)