View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default 2 formulas in 1 cell

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

"Teethless mama" wrote:

=(B2B1)*B1


"MAX" wrote:

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