Thread: sumif function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default sumif function
Actually, that's one too many functions. Try:

= ABS(A1) + 50*(A1<0)

In article ,
JE McGimpsey wrote:

For one cell:

=IF(A1<0,ABS(A1)+50,A1)
Reply With QuoteReply With Quote