Vlookup & If statement

R

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
 
B

Bob Phillips

=MAX(vlookup_formula,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top