Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Excel: how to convert "27.11.2007 15:13" to number (cellformat fai | Excel Discussion (Misc queries) | |||
convert number to its letters ( convert "1" to "One" ) | Excel Discussion (Misc queries) | |||
function to convert number to words [ 21 = "twenty one " ] | Excel Worksheet Functions | |||
How can I convert a Number into words. Ex: "10" as "Ten" | Excel Worksheet Functions |