| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Formula to calculate n*'cell value' where n is any integer
I want to create a formula to calculate a formula such as the following:
=($F14+1)/(n*$D14) where n can be any integer from 0 to 20 If will be part of a larger IF statement. How can this be set up? Do I need to set up a hidden array with the values 0 to 20, but even then, how would the formula be programmed? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Formula to calculate n*'cell value' where n is any integer
How are you deciding which value of n to use in any particular case?
If it is a random choice, then =($F14+1)/(RANDBETWEEN(0,20)*$D14) but bear in mind that if n is 0 you'll get a divide by zero error. -- David Biddulph "Elliott-DECA" wrote in message ... I want to create a formula to calculate a formula such as the following: =($F14+1)/(n*$D14) where n can be any integer from 0 to 20 If will be part of a larger IF statement. How can this be set up? Do I need to set up a hidden array with the values 0 to 20, but even then, how would the formula be programmed? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| only INTEGER INPUT IN CELL | Excel Worksheet Functions | |||
| Spreadsheet shows the formula in the cell but doesn't calculate | Excel Discussion (Misc queries) | |||
| Can you calculate a formula in the same cell where you enter the d | Excel Discussion (Misc queries) | |||
| formula won't calculate unless I click cell | Excel Worksheet Functions | |||
| X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions | |||
Linear Mode
