| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM and IF results
Arvi!
Thanks, I love the simple solutions. David "Arvi Laanemets" wrote: Hi Replace your formula with =IF(C2<2,50,IF(C2=2,25,IF(C23,0))) But what about 3=C22 Btw. you can do without any IF's (slightly different conditions in my example here) =50-(C2=2)-(C22) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "David" wrote in message ... 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why Different results | Excel Discussion (Misc queries) | |||
| different results | Excel Discussion (Misc queries) | |||
| Sum of If Results. How? | Excel Worksheet Functions | |||
| Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
| min or max results | Excel Worksheet Functions | |||
Threaded Mode
