how do i setup an if, then statement
 

i want to test a cell - a2 - for a value 0
if 0 i want to multiply a1*a2
else do nothing
t.i.a.

how do i setup an if, then statement
 

One way:

=IF(A20,A1*A2,"")

The "" is a null string, so it technically doesn't "do nothing"
(functions always return some value), but it won't display anything.


In article ,
"steve" wrote:

i want to test a cell - a2 - for a value 0
if 0 i want to multiply a1*a2
else do nothing
t.i.a.