Interpolation of values

[SAHIL18]

Dear Sir,

I am righting a formula using if condition and v-lookup command where I am facing a problem. I have four column assume P=0.05 Q=0.1 R=0.15 S=0.2. Formula as stated below.

=IF($X$125=20,IF($Y$125=500,IF($Z$125>=0.05<=0.1,VLOOKUP(REFRENCE CELL NUMNER,RANGE,TRUE),"ERROR")))

The highlighted command of <= does not work, and i need to interpolate the values in from vlookup range for the given condition.

Please assist me how can i do this.
for any additional information please revert back


Regards


Sahil

 

[jarjarbingie]

Dear Sir,

I am righting a formula using if condition and v-lookup command where I am facing a problem. I have four column assume P=0.05 Q=0.1 R=0.15 S=0.2. Formula as stated below.

=IF($X$125=20,IF($Y$125=500,IF($Z$125>=0.05<=0.1,VLOOKUP(REFRENCE CELL NUMNER,RANGE,TRUE),"ERROR")))

The highlighted command of <= does not work, and i need to interpolate the values in from vlookup range for the given condition.

Please assist me how can i do this.
for any additional information please revert back


Regards


Sahil

=IF($X$125=20,IF($Y$125=500,IF(and($Z$125>=0.05,$Z$125<=0.1),VLOOKUP(REFRENCE CELL NUMNER,RANGE,TRUE),"ERROR")))

 

[SAHIL18]

=IF($X$125=20,IF($Y$125=500,IF(and($Z$125>=0.05,$Z$125<=0.1),VLOOKUP(REFRENCE CELL NUMNER,RANGE,TRUE),"ERROR")))

Dear Sir,

Thanks for ur reply.

I need to have interpolated results of value lying inbetween. and how do i do that in V-lookup


Regards


Sahil

 

[jarjarbingie]

Dear Sir,

Thanks for ur reply.

I need to have interpolated results of value lying inbetween. and how do i do that in V-lookup


Regards


Sahil

can you provide an example?

 

[SAHIL18]

can i send the excel file with the whole program

 

[jarjarbingie]

can i send the excel file with the whole program

ygpm..