| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Functions Problem
What function do you use to get the value of one cell to be 50 for every 1000
value of another cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Functions Problem
I am notsure if this is what you mean
try this =if(a1=1000,50,"") Click yes if helped -- Greatly appreciated Eva "Confused" wrote: What function do you use to get the value of one cell to be 50 for every 1000 value of another cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Functions Problem
Confused wrote:
What function do you use to get the value of one cell to be 50 for every 1000 value of another cell? =A1/20 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Functions Problem
If you want for 1000 = 50 and 2000 = 100 then
=A1*.05 this will return 37.5 for a value of 750 if you only want it to increase when a value increases by 1000 try =INT(A1/1000)*50 HTH Peter "Confused" wrote: What function do you use to get the value of one cell to be 50 for every 1000 value of another cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Functions and Formulas | Excel Worksheet Functions | |||
| Problem with sumproduct, countif functions.. | Excel Worksheet Functions | |||
| Problem with functions working | New Users to Excel | |||
| formatting problem with functions | Excel Worksheet Functions | |||
| Problem using VBA functions.... | New Users to Excel | |||
Linear Mode
