Thread: SUM and IF results
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
  
Posts: 1,560
Default SUM and IF results
I want to SUM a horizontal row of cells, of which one contains the IF function:
=IF(C2<2,"50",IF(C2=2,"25",IF(C23,"0")))

I want the results of the IF function, 50, 25, or 0, to be included in the
SUM.
Any tips?
Reply With QuoteReply With Quote