How would you solve a function with input 1 output 8.

Then input 2 output 14.

next input 3 output is blank

then input is blank Output is 24.

the input is blank and the out put is 28.

Finally, the input is 6 and the output is blank.

First the bad news: I don't think you can use Excel to just give you the
function you require (by typing in the inputs and outputs).

The good news: you could use Excel to test a function you come up with
yourself.

It seems reasonable that the Input 'blanks' in your data are 4 and 5. This
gives a series of input/ouput pairs as (1,8) (2,14) (3,?) (4,24) (5,28)
(6,?). So if you type the numbers 1 to 6 in say cells A1 to A6, then you can
try different 'functions' in cells B1 to B6, such as using a formula in B1
like =(A1*2) + 6

Then drag fill this formula down to B6, so that B2 holds formula =(A2*2) +
6, B3 holds formula =(A3*2) + 6 etc.

This formula would translate to a function: output = (input x 2) + 6

This isn't the function you're looking for by the way, but you should be
able to find the one you need with some maths playing about!

Regards,

Tom


"Jpleasant" wrote:

How would you solve a function with input 1 output 8.

Then input 2 output 14.

next input 3 output is blank

then input is blank Output is 24.

the input is blank and the out put is 28.

Finally, the input is 6 and the output is blank.