Hi, i need an code with 12 arguments.

=IF(A1<H1,H1,IF(A1<H2,H2,IF(A1<H3,H3,IF(A1<H4,H4,I F(A1<H5,H5,IF(A1<H6,H6,IF(A1<H7,H7,IF(A1<H8,H8)))) ))))

This code is not working with more than 8 arguments, and i need 12.
I tried =choose, but still not working.
Any ideea?

Thanks!

Without seeing your data, not sure if this will work perfectly, but you could
do something like:
=LOOKUP(A1+1,H1:H8)

The +1 is only in there because your arguements were less than (not less
than or equal). I'm also assuming the values in H1:H8 are at least more than
1 apart from each other.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"puiuluipui" wrote:

Hi, i need an code with 12 arguments.

=IF(A1<H1,H1,IF(A1<H2,H2,IF(A1<H3,H3,IF(A1<H4,H4,I F(A1<H5,H5,IF(A1<H6,H6,IF(A1<H7,H7,IF(A1<H8,H8)))) ))))

This code is not working with more than 8 arguments, and i need 12.
I tried =choose, but still not working.
Any ideea?

Thanks!

Hi,
H1=10000
H2=20000
H3=30000
....
....
H12=120000

let's say that A1=1250
1250 is smaller than 10000.i need the code to look in H1:H12 and in B1 the
code to display 8750, and in C1 to display 10000.
if A1=48000, result to be: B1=2000 and C1=50000

in C column i need a formula that retrieve the closes data from H column and
in B column the "same code"-A1





"Luke M" a scris:

Without seeing your data, not sure if this will work perfectly, but you could
do something like:
=LOOKUP(A1+1,H1:H8)

The +1 is only in there because your arguements were less than (not less
than or equal). I'm also assuming the values in H1:H8 are at least more than
1 apart from each other.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"puiuluipui" wrote:

Hi, i need an code with 12 arguments.

=IF(A1<H1,H1,IF(A1<H2,H2,IF(A1<H3,H3,IF(A1<H4,H4,I F(A1<H5,H5,IF(A1<H6,H6,IF(A1<H7,H7,IF(A1<H8,H8)))) ))))

This code is not working with more than 8 arguments, and i need 12.
I tried =choose, but still not working.
Any ideea?

Thanks!

Use the array formula:

=MIN(IF(H1:H12$A$1,(H1:H12)-$A$1,MAX(H1:H12)))+$A$1

Array formulas are entered with "CTRL + SHIFT + ENTER"

See : http://www.cpearson.com/excel/ArrayFormulas.aspx


"puiuluipui" wrote:

Hi, i need an code with 12 arguments.

=IF(A1<H1,H1,IF(A1<H2,H2,IF(A1<H3,H3,IF(A1<H4,H4,I F(A1<H5,H5,IF(A1<H6,H6,IF(A1<H7,H7,IF(A1<H8,H8)))) ))))

This code is not working with more than 8 arguments, and i need 12.
I tried =choose, but still not working.
Any ideea?

Thanks!

HI, WORKS GREAT!!

Thanks allot!



"dhstein" a scris:

Use the array formula:

=MIN(IF(H1:H12$A$1,(H1:H12)-$A$1,MAX(H1:H12)))+$A$1

Array formulas are entered with "CTRL + SHIFT + ENTER"

See : http://www.cpearson.com/excel/ArrayFormulas.aspx


"puiuluipui" wrote:

Hi, i need an code with 12 arguments.

=IF(A1<H1,H1,IF(A1<H2,H2,IF(A1<H3,H3,IF(A1<H4,H4,I F(A1<H5,H5,IF(A1<H6,H6,IF(A1<H7,H7,IF(A1<H8,H8)))) ))))

This code is not working with more than 8 arguments, and i need 12.
I tried =choose, but still not working.
Any ideea?

Thanks!