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