G Guest Jan 2, 2005 #1 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.
J JE McGimpsey Jan 2, 2005 #2 One way: =IF(A2>0,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.
One way: =IF(A2>0,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.