If cell B2<B1 answer in A2 must be 0 and
if cell B2B1 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" wrote in message
...
If cell B2<B1 answer in A2 must be 0 and
if cell B2B1 answer in A2 must be equal to B1

=IF(B2<B1,0,IF(B2B1,B1,"I haven't a clue what answer is required if B2=B1,
so I haven't specfied it"))
--
David Biddulph

MAX wrote:
If cell B2<B1 answer in A2 must be 0 and
if cell B2B1 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" wrote in message
...
If cell B2<B1 answer in A2 must be 0 and
if cell B2B1 answer in A2 must be equal to B1

=(B2B1)*B1


"MAX" wrote:

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

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

"Teethless mama" wrote:

=(B2B1)*B1


"MAX" wrote:

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