| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM and IF functions
Also you don't need the last IF
=IF(C2<2,50,IF(C2=2,25,0)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob I" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| functions to use | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
| Functions | Excel Worksheet Functions | |||
Linear Mode
