| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
=IF(AD7<0,AD7*-1,0)
& =IF(AD13=0,AD13,0) I'm not sure I understand about changing True to 0, though. Redleg40 wrote: =IF(AD7<0,AD7*-1) & =IF(AD13=0,AD13) "Jambruins" wrote: what is the formula you are using? "Redleg40" wrote: How do change values of TRUE or FALSE to 0? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel | |||
| How do I change x axis values in a line chart? | Charts and Charting in Excel | |||
| link data to new workbook | Excel Discussion (Misc queries) | |||
| Paste Special in a macro | Excel Worksheet Functions | |||
| Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel | |||
Threaded Mode
