Problem
I have the set of data,

Value Fee
A B C

Min Max
£0.00 £4.99 £0.45
£5.00 £9.99 £0.85
£10.00 £99.99 £0.09
£100.00 £250.00 £8.75


I have used Vlookup to build the function.
=IF(VLOOKUP(B12,$A$3:$C$7,3)=$C$5,$C$5*B12,VLOOKUP (B12,$A$3:$C$6,3)).
What I am looking for is that when the value is over 250, it should
divide it by 250 and return the rate appropriately. If it is nil it
should return 0

Can someone help?
Please find attached


+-------------------------------------------------------------------+
|Filename: TropezfnPO Management.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4615 |
+-------------------------------------------------------------------+

--
tropezfn
------------------------------------------------------------------------
tropezfn's Profile: http://www.excelforum.com/member.php...o&userid=33351
View this thread: http://www.excelforum.com/showthread...hreadid=531845