View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default SUM and IF functions

lose the quote marks, SUM doesn't like text.

David wrote:

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