| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding results from a If formula-Short in time
how do I add the results of if formulas =if(I3="YES","5", IF(I3="NO", "0")).
or how can I convert the results of this if formula to a number and later add it at the end of the row. thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding results from a If formula-Short in time
For real numbers, do not wrap within double quotes
Try it like this, in say J3, copied down: =IF(I3="YES",5,IF(I3="NO",0,"")) Then you can sum it easily using SUM Eg in say, J11: =SUM(J3:J10) -- Max Singapore http://savefile.com/projects/236895 Downloads:17,500 Files:358 Subscribers:55 xdemechanik --- "Diana" wrote: how do I add the results of if formulas =if(I3="YES","5", IF(I3="NO", "0")). or how can I convert the results of this if formula to a number and later add it at the end of the row. thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding results from a If formula-Short in time
=(I3="YES")*5
"Diana" wrote: how do I add the results of if formulas =if(I3="YES","5", IF(I3="NO", "0")). or how can I convert the results of this if formula to a number and later add it at the end of the row. thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having a problem formatting short time | New Users to Excel | |||
| Formula for adding time eg. 13:45 + 22:15 + 10:45 + 19:30 | New Users to Excel | |||
| SUM problem: adding formula results | Excel Discussion (Misc queries) | |||
| Date & time short cut | Excel Worksheet Functions | |||
| What is the formula to display a negative time results? | Excel Worksheet Functions | |||
Linear Mode
