M
MAX
If cell B2<B1 answer in A2 must be 0 and
if cell B2>B1 answer in A2 must be equal to B1
if cell B2>B1 answer in A2 must be equal to B1
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
In A2:
=IF(B2<B1,0,B1)
But what if B2 = B1?
Please be always very specific with >, < >=, <=, etc
=IF(B2<B1,0,B1)
But what if B2 = B1?
Please be always very specific with >, < >=, <=, etc
D
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"))
so I haven't specfied it"))
M
MAX
It works perfectly with the formula you gave me.
T
Teethless mama
=(B2>B1)*B1
M
MAX
Thank you for your formula, I will use this in the future