How do change values of TRUE or FALSE to 0?

what is the formula you are using?


"Redleg40" wrote:

How do change values of TRUE or FALSE to 0?

=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?

Put a 0 in for the value_if_false argument. Standard IF syntax:
=IF(condition,value_if_true,value_if_false), so for your first formula:
=IF(AD7<0,AD7*-1,0)


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=392143

=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