 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006calculating a price
I have a total of funds available of $3000 and tax of 7% and want to find out what is the highest base price that I could enter and max out at $3000. Base number + (Base number X .07) = $3000 I used the trial and error method and came up with $2804. What formula could I use that would do this for me? One way: =Base number / (1 + 0.07) > I have a total of funds available of $3000 and tax of 7% and want to find out > what is the highest base price that I could enter and max out at $3000. > Base number + (Base number X .07) = $3000 > I used the trial and error method and came up with $2804. What formula > could I use that would do this for me? With 3000 in A1 and .07 in B1, put this in C1 =A1/(1+B1) Vaya con Dios, Chuck, CABGx3 > I have a total of funds available of $3000 and tax of 7% and want to find out > what is the highest base price that I could enter and max out at $3000. > Base number + (Base number X .07) = $3000 > I used the trial and error method and came up with $2804. What formula > could I use that would do this for me? One play using goal seek .. Put in C1: =A1+A1*B1 Enter in B1: 0.07 Select C1, click Tools > Goal Seek Set cell: C1 To value: 3000 By changing cell: A1 Click OK Excel informs a solution is found, with a value in A1 of: 2803.738  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > I have a total of funds available of $3000 and tax of 7% and want to find out > what is the highest base price that I could enter and max out at $3000. > Base number + (Base number X .07) = $3000 > I used the trial and error method and came up with $2804. What formula > could I use that would do this for me? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.