2 formulas in 1 cell

[MAX]

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

 

[Niek Otten]

In A2:

=IF(B2<B1,0,B1)

But what if B2 = B1?

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

 

[David Biddulph]

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

 

[MAX]

It works perfectly with the formula you gave me.

 

[Teethless mama]

=(B2>B1)*B1

 

[MAX]

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