 |
 | 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 / May 2008Auto "convert" a number to a different number
I have a cell that will display a number, i.e. 0.25, by the use of the formula =LARGE(P3:P43,1). I want to use this cell in a division formula in a second cell, but when inserted into the second formula, I want the 0.25 to be "converted" to 0.9. I don't want to change the appearance of the first cell (still want it to show 0.25), but I want 0.9 to be used in the second formula. The range of numbers that can show up in the first cell are from 0.15 to 0.75. The range of "converted" numbers are from 1 to 0.4. 0.15 = 1 0.16 = 0.99 0.17 = 0.98 0.18 = 0.97 and so on and so on :) Is it possible to do what I am asking? Thank you Hi Rick assuming you have 2 columns on Sheet2 with your values in column A and the values you want to use in column B, then =VLOOKUP(LARGE(P3:P43,1).,Sheet2!$A:$B,2,0) should return the value you need to use.  SignatureRegards Roger Govier > I have a cell that will display a number, i.e. 0.25, by the use of the > formula =LARGE(P3:P43,1). I want to use this cell in a division formula in [quoted text clipped - 15 lines] > Is it possible to do what I am asking? > Thank you Thank you gentlemen, that worked perfectly !!! I am truely grateful :) > Hi Rick > [quoted text clipped - 23 lines] > > Is it possible to do what I am asking? > > Thank you Rick I would set your conversions up in a second table, even on another sheet and then refer to that, so if your original number is in A1 on sheet 1 and the table of conversions in say A1:B100 on sheet2 then something like =Your_new_number/VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE) Replace Your_New_Number with the reference to the cell with your other number in SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk > I have a cell that will display a number, i.e. 0.25, by the use of the > formula =LARGE(P3:P43,1). I want to use this cell in a division formula in [quoted text clipped - 15 lines] > Is it possible to do what I am asking? > Thank you =1-Q5+0.15 Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I have a cell that will display a number, i.e. 0.25, by the use of the > formula =LARGE(P3:P43,1). I want to use this cell in a division formula in [quoted text clipped - 15 lines] > Is it possible to do what I am asking? > Thank you |
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
|
©2008 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.