multiple functions

Hello all, I just picked up on excel functions over the past couple days, but I've come to a holding point and need some insight on this. I'm making a sheet to use linear interpolation the rescale some values, hopefully someone can give me some insight on what is wrong with this code. Thanks!

Code I need some help with:

=IF(SMALL(C6:C25,1)>C30,SMALL(C6:C25,1),IF(C30>LARGE(C6:C25,1),C30,IF(1=COUNTIF(C6:C25,C30),C30,OFFSET(C6,MATCH(C30,C6:C25,-1),0,1,1))))

C6: 500
C7: 1000
C8: 2000
C9: 3000
C10: 4000
C11: 5000
C12: 6000
C13: 7000
C14: 8000
C15: 9000
C16: 10000
C17: 11000
C18: 12000
C19: 13000
C20: 14000
C21: 15000
C22: 16000
C23: 17000
C24: 18000
C25: 19000

C30: 600

Thanks guys, appreciate the much needed help

Hi

Change the -1 to 1 in the MATCH component. Your data is in ascending order.


rylo

Wow, thanks. I'm making a somewhat large excel spreadsheet for car data. I'll post any other problems I encounter.