Vlookup & If statement

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 returns is less than zero I want to return zero. If the value that the vlookup returns is greater than zero then I want to see that value.

Any Help would be appreciated

=MAX(vlookup_formula,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"rmeister" <rmeister.23wc7z_1141057801.2867@excelforum-nospam.com> wrote in
message news:rmeister.23wc7z_1141057801.2867@excelforum-nospam.com...
>
> 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 returns
> is less than zero I want to return zero. If the value that the vlookup
> returns is greater than zero then I want to see that value.
>
> Any Help would be appreciated
>
>
> --
> rmeister
> ------------------------------------------------------------------------
> rmeister's Profile:
http://www.excelforum.com/member.php...o&userid=30163
> View this thread: http://www.excelforum.com/showthread...hreadid=516906
>

Hi

Try something like:

=MAX(your vlookup,0)

Andy.

"rmeister" <rmeister.23wc7z_1141057801.2867@excelforum-nospam.com> wrote in
message news:rmeister.23wc7z_1141057801.2867@excelforum-nospam.com...
>
> 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 returns
> is less than zero I want to return zero. If the value that the vlookup
> returns is greater than zero then I want to see that value.
>
> Any Help would be appreciated
>
>
> --
> rmeister
> ------------------------------------------------------------------------
> rmeister's Profile:
> http://www.excelforum.com/member.php...o&userid=30163
> View this thread: http://www.excelforum.com/showthread...hreadid=516906
>