View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default if/then statement

Hi,

Maybe something like this:

=SUM(A1:A10)+IF(B1=0,0,1)

HTH
Jean-Guy

"PoolPool" wrote:

I am attempting to add a value of "1" to the output of a formula from a
different cell. However, if the the value of the other cell is "0", I do not
want the "1" added.

I need to have a correlating "0" with the other "0".

Thanks.