Thread: SumProduct Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
  
Posts: 355
Default SumProduct Help
Hello
I need to modify my sumproduct formula:

SUMPRODUCT(ROUNDUP(Q4:AY4*1.02,0))

Such that if Q4:AY4 0 ROUNDUP(Q4:AY4*1.02,0) and if < 0 abs(Q4:AY4)

Thanks
Reply With QuoteReply With Quote