Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a cell value using another cells value | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |