Thread: subtracting 2 cells but only if 1st cell is greater than 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maureen Maureen is offline
external usenet poster
  
Posts: 32
Default subtracting 2 cells but only if 1st cell is greater than 0
In cell e11 I would like to subtract cell d11-c11 unless the calue in c11 is
, or = to 0, in which case, I would like e11 to be 0. i have tried severeral
=if and sumif formulas and can't get anything to work. Any suggestions?
Reply With QuoteReply With Quote