Try this:

=MIN(500,IF(B5<0.01,0,B5*LOOKUP(B5,{0;6001},{0.012 ;0.009})+18))

--
Biff
Microsoft Excel MVP


"Ross" wrote in message
...
Hi Everyone

The formula that I already have is:
=IF(B5<0.01,0,IF(B5<6001,(B5*0.012)+18,IF(B56000, (B5*0.009)+18,0))) I
need
to add something to cap the result at 500. Can someone help?

Thanks...
--
smither fan