How do I change FALSE values to 0?

Redleg40 · 08-02-2005, 10:05 AM

How do change values of TRUE or FALSE to 0?

Jambruins · 08-02-2005, 11:05 AM

what is the formula you are using?

"Redleg40" wrote:

> How do change values of TRUE or FALSE to 0?

Redleg40 · 08-02-2005, 12:05 PM

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

**MrShorty** · 08-02-2005, 02:39 PM

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)

Dave Peterson · 08-02-2005, 04:05 PM

=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