Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF(ISNA formula problem | Excel Worksheet Functions | |||
Formula Problem | New Users to Excel | |||
Need a formula for this problem | Excel Worksheet Functions | |||
Baffling formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) |