R
Redleg40
How do change values of TRUE or FALSE to 0?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jambruins
what is the formula you are using?
R
Redleg40
=IF(AD7<0,AD7*-1)
&
=IF(AD13>=0,AD13)
&
=IF(AD13>=0,AD13)
Jambruins said:what is the formula you are using?
M
MrShorty
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
=IF(condition,value_if_true,value_if_false), so for your first formula
=IF(AD7<0,AD7*-1,0
D
Dave Peterson
=IF(AD7<0,AD7*-1,0)
&
=IF(AD13>=0,AD13,0)
I'm not sure I understand about changing True to 0, though.
&
=IF(AD13>=0,AD13,0)
I'm not sure I understand about changing True to 0, though.