P
Pank
I have the following dilemma.
I have a Vlookup, which tests for values between 110 and 131 and allocates
an appropriate bonus that works fine. If the values are less than 110 and
greater then 130 the resultant cell displays #N/A as expected.
However I have now been advised that if I have a value that is less than or
equal to 110 I need to allocate a bonus of 86.49 and if it is greater than or
equal to 131 I need to allocate a bonus of 102.00. Any value between 110 and
131 should invoke the vlookup to allocate the appropriate bonus.
I was hoping to using an ‘if then else’ statement to set the low and
high-end bonus prior to the vlookup.
I have keyed the formula in as
=IF(D25<110,F37=86.49,D25>130,F37=102.00,VLOOKUP(D25,B28:C50,2,TRUE))
However, I get a message that says ‘the formula you typed contains an
error’. I have tried to go through the help but I keep hitting a brick wall.
Any help would be appreciated.
I have a Vlookup, which tests for values between 110 and 131 and allocates
an appropriate bonus that works fine. If the values are less than 110 and
greater then 130 the resultant cell displays #N/A as expected.
However I have now been advised that if I have a value that is less than or
equal to 110 I need to allocate a bonus of 86.49 and if it is greater than or
equal to 131 I need to allocate a bonus of 102.00. Any value between 110 and
131 should invoke the vlookup to allocate the appropriate bonus.
I was hoping to using an ‘if then else’ statement to set the low and
high-end bonus prior to the vlookup.
I have keyed the formula in as
=IF(D25<110,F37=86.49,D25>130,F37=102.00,VLOOKUP(D25,B28:C50,2,TRUE))
However, I get a message that says ‘the formula you typed contains an
error’. I have tried to go through the help but I keep hitting a brick wall.
Any help would be appreciated.