Hi Pank,

Your formula is incorrect. Have you tried the one I suggested earlier?

=IF(D25<110,86.49,IF(D25130,102,VLOOKUP(D25,B28:C 50,2)))

If yes, what was the problem?

Regards,
KL


"Pank" wrote in message
...
Apologies to all for not explaining my problem correctly.

Second attempt:-


I have the following Vlookup formula in cell F37
=VLOOKUP(D25,B28:C50,2,TRUE), 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 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 (in F37) to set the low
and high-end bonus prior to the vlookup (which is currently in F37).

I have keyed the formula in as: -
=IF(D25<110,F37=86.49,D25130,F37=102.00,VLOOKUP(D2 5,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.



"paul" wrote:


-- sorry for 140 in formula read 102....
paul
remove nospam for email addy!



"paul" wrote:

=IF(D25<=110,86.49,IF(D25<131,VLOOKUP(D25,B28:C50, 2,TRUE),140))

--
paul
remove nospam for email addy!



"Pank" wrote:

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,D25130,F37=102.00,VLOOKUP(D 25,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.