View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 2 formulas in 1 cell

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