| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
X Factor into Percent...
So I have an entry field where I am putting a number, usually between 1 and
4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is. How much storage savings. Any suggestions? Joe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
X Factor into Percent...
Isn't it just:
=1 / X_factor expressed/formatted as a percentage? Hope this helps. Pete On Feb 24, 1:10*am, Joseph Hand wrote: So I have an entry field where I am putting a number, usually between 1 and 4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is.. How much storage savings. Any suggestions? Joe |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
X Factor into Percent...
You know when you stare at something for so long, you can't see it clear head
on? Thank you Pete! joe "Pete_UK" wrote: Isn't it just: =1 / X_factor expressed/formatted as a percentage? Hope this helps. Pete On Feb 24, 1:10 am, Joseph Hand wrote: So I have an entry field where I am putting a number, usually between 1 and 4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is.. How much storage savings. Any suggestions? Joe . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
X Factor into Percent...
You're welcome, Joe - thanks for feeding back.
Pete On Feb 24, 3:37*am, Joseph Hand wrote: You know when you stare at something for so long, you can't see it clear head on? Thank you Pete! joe "Pete_UK" wrote: Isn't it just: =1 / X_factor expressed/formatted as a percentage? Hope this helps. Pete On Feb 24, 1:10 am, Joseph Hand wrote: So I have an entry field where I am putting a number, usually between 1 and 4, by tenths, and dividing a set amount of data storage in MB by that number, to reflect the amount of actual data stored. This x Factor is a "Compression and Deduplication" number. For example, if I have an X Factor for Comp/Dedupe of 2, that means my 1000MB of actual data takes up 500MB of space, hence 50% of the room. What I want to do is figure out, based on X Factor, what my percentage is.. How much storage savings. Any suggestions? Joe .- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time factor | Excel Worksheet Functions | |||
| Factor Analysis | Excel Worksheet Functions | |||
| IF FACTOR? | Excel Discussion (Misc queries) | |||
| Growth Factor | Excel Discussion (Misc queries) | |||
| Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
Linear Mode
