| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a cell when I type 10 it will multiply 10 by .585
I'm trying to format a cell in a way where the number I input will
automatically be multiplied by a number predetermined by me. ie: I format cell a1 so it's contents is multiplied by .585 when I input the number 10 in cell a1 it will display as 5.85 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set a conditional format that is dependent on cell type | Excel Discussion (Misc queries) | |||
| "If this, multiply by this" type of equation | Excel Worksheet Functions | |||
| Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
| Change Excel cell format date type examples ("14-Mar-01") | Setting up and Configuration of Excel | |||
| Can I set the numerical type of Cell to Hex format | Excel Discussion (Misc queries) | |||
Threaded Mode
