=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