LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How to reverse this formula?

I want to change this formula. Right now it is a guessing game on how
to get the formula to equate to the ideal value of .28.
..28=(((E5-(B5*1000*1.305/2080))-D5-C5)/(E5))
E5 represents the number I enter to try to to get to .28
B5 is a number that varies all the time, so I enter different numbers
in B5 in an attempt to get to the right value so the formula equates to
..28
D5 and C5 are constants.
What would the formula look like in order to have .28 be within the
formula, so that I can enter any number as B5 and the result is
whatever the number E5 needs to be? In other words, I want E5 to be
the answer, not .28.

 
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
How to reverse an Excel formula? Nige Excel Worksheet Functions 2 December 4th 09 12:53 PM
Looking to reverse a quadratic formula, Sqrt and all?? DataSchemer Excel Discussion (Misc queries) 3 August 14th 09 02:36 PM
Reverse Fees Linear Formula Roddy Excel Discussion (Misc queries) 2 May 27th 08 09:20 PM
How do I create a reverse julian date formula? GaryM Excel Worksheet Functions 6 October 2nd 07 03:19 PM
Is there an formula to reverse the order of a number sequence? [email protected] Excel Discussion (Misc queries) 3 November 1st 06 04:47 PM


All times are GMT +1. The time now is 01:09 AM.

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

About Us

"It's about Microsoft Excel"