View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.