LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Cal
 
Posts: n/a
Default need help with determining a formula

open a spreadsheet and place the following value(s)...

(cell A1) $50000 ..., this entry represents a fixed dollar amount
(cell B1) 0.025 ..., this entry represents a "rate"
(cell C1) 25 ..., this entry represents a fixed amount of years
(cell D1) 0.020 ..., this entry represents a seperate "rate"
(cell E1) 5 ..., this entry represents additional amount of years
(cell F1's formula) =(A1*B1*C1)+(A1*D1*E1) ..., this produces $36250
(cell G1's formula) =F1/A1 ..., this produces 72.5%, (or .0725)
(cell H1's formula) is where I need help?

I cannot deterime the formula that will report, "What amount of total years
will produce a result of 78% (.078) in G1's cell? 25 plus "whatever"
additional years?
P.S. (C1+E1)/G1*.78 does not produce the correct formula/answer. I know
that the correct answer is, 32.75 (years) or otherwords 7.75 in E1's cell,
but I cannot figure out the formula that will provide that answer!

Thanks for your help...


-
rudy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
writing a formula for a colored value aaronwexler New Users to Excel 11 September 1st 05 03:11 PM
referencing named formula using INDIRECT function [email protected] Excel Worksheet Functions 19 May 11th 05 09:48 AM
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"