if/then statement

P

PoolPool

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.
 
S

Sandy Mann

If you mean have a formula that displays 1 more then the output of another
cell or zero if the other cell is zero then try:

=if(Othercell<>0,Othercell+1,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
Top