If cell B2<B1 answer in A2 must be 0 and
if cell B2>B1 answer in A2 must be equal to B1

In A2:

=IF(B2<B1,0,B1)

But what if B2 = B1?

Please be always very specific with >, < >=, <=, etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MAX" <(E-Mail Removed)> wrote in message
news:2FDDE28C-020E-4E77-BB01-(E-Mail Removed)...
> If cell B2<B1 answer in A2 must be 0 and
> if cell B2>B1 answer in A2 must be equal to B1

It works perfectly with the formula you gave me.

"Niek Otten" wrote:

> In A2:
>
> =IF(B2<B1,0,B1)
>
> But what if B2 = B1?
>
> Please be always very specific with >, < >=, <=, etc
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "MAX" <(E-Mail Removed)> wrote in message
> news:2FDDE28C-020E-4E77-BB01-(E-Mail Removed)...
> > If cell B2<B1 answer in A2 must be 0 and
> > if cell B2>B1 answer in A2 must be equal to B1
>
>

=(B2>B1)*B1


"MAX" wrote:

> If cell B2<B1 answer in A2 must be 0 and
> if cell B2>B1 answer in A2 must be equal to B1

Thank you for your formula, I will use this in the future

"Teethless mama" wrote:

> =(B2>B1)*B1
>
>
> "MAX" wrote:
>
> > If cell B2<B1 answer in A2 must be 0 and
> > if cell B2>B1 answer in A2 must be equal to B1