Need Formula to calculate n*'cell value' where n is any integer

[Elliott-DECA]

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.

 

[David Biddulph]

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.