M MAX Feb 20, 2009 #1 If cell B2<B1 answer in A2 must be 0 and if cell B2>B1 answer in A2 must be equal to B1
N Niek Otten Feb 20, 2009 #2 In A2: =IF(B2<B1,0,B1) But what if B2 = B1? Please be always very specific with >, < >=, <=, etc