Help writing a Apple Numbers Spreadsheet embedded IF function that test 5 conditions and returns 5 values.

if 1 = 2, 2=4,3=6 etc... Its just value *2

=R2*2

however to nest functions like this you wouldn't do > and < just =

If(R2=1,2,if(r2=2,4,.... etc.... 

If you want to do a set of conditions you would use AND

If(AND(R2>0,R2<2),2,If(....

If =R2*2 doesn't capture all your cases then you can use SWITCH or IFS, which are much easier than nested ifs.

To use SWITCH:

=SWITCH(R2,1,2,2,4,3,6,4,8,5,10)

This references R2 and is simply followed by switch-value, if-match pairs.

More on SWITCH here:

SWITCH - Apple Support

IFS is a similar idea, a little more complicated for this particular case, but useful for dealing with in inequalities (> and < , etc). In this case you could use this:

=IFS(R2=1,2,R2=2,4,R2=3,6,R2=4,8,R2=5,10)

More on IFS here:

IFS - Apple Support

Either way no need to get tangled up in logic of nested ifs.

SG

Hi tcwestover,

Here is a way to deal with numbers that are not integers.

Formula in Data B2:

XLOOKUP(A2,Lookup::A,Lookup::B,"Not Found",-1,1)

Regards,

Ian.