View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default SUM and IF functions

I want to use the numeric value returned in a cell by the following function
as part of a horizontal SUM function:
=IF(C2<2,"50",IF(C2=2,"25",IF(C23,"0")))
As is, the SUM ignores the value returned by this function.
How do I get the SUM to recognize the numeric value?
Thanks