add cells if the value of another cell =?

B

bill gras

I have in cell F26 numbers from 0-24, I need to ad together cells K52 and J52
only if cell F26 does not contains number 1, if cell F26 contains number 1, I
do not add cells K52 and J52 together, Ijust need cell K52 on its own.
I'm using excel 2000

Can any one please help

regards bill gras
 
M

mangesh_yadav

=K52+IF(F26<>1,J52,0)

Mangesh


I have in cell F26 numbers from 0-24, I need to ad together cells K52
and J52 only if cell F26 does not contains number 1, if cell F26
contains number 1, I
do not add cells K52 and J52 together, Ijust need cell K52 on its own.
Click to expand...
 
M

MartinShort

In your target cell type:

=IF(F26=1,K52,SUM(K52,J52))

or

=IF(F26=1,K52,K52+J52)

They do the same thing.
 
Top