you don't provide enough info but
if(myformulacriteria,myformula,criteria)

--
Don Guillett
SalesAid Software

"martin" wrote in message
...

I have a vlookup formula that gives me a certain figure from a preset
list,
but I need to be able to link this to a set criteria if the number equals
this or goes above then these figures take president over the vlookup
answer
?????