Vlookup & If statement

[rmeister]

I am trying to write a formula that returns the following:

I am wanting to do a Vlookup and if the value that the vlookup return
is less than zero I want to return zero. If the value that the vlooku
returns is greater than zero then I want to see that value.

Any Help would be appreciate

 

[Bob Phillips]

=MAX(vlookup_formula,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi

Try something like:

=MAX(your vlookup,0)

Andy.