add cells if the value of another cell =?
 

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

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

--
HTH

Bob Phillips

"bill gras" <bill wrote in message
...
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

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


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378910

In your target cell type:

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

or

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

They do the same thing.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=378910