Home |
Search |
Today's Posts |
#1
|
|||
|
|||
add cells conditionaly not in continuous row or column
I need to add two cells not in a continuous row or column, say B8 and C7, but
only if the value in C7 is less than zero. If value in C7 is more than zero need the cell to equal the value in B8 |
#2
|
|||
|
|||
add cells conditionaly not in continuous row or column
=IF(C7<0,B8+C7,B8)
Hope this helps Rowan loganinc6 wrote: I need to add two cells not in a continuous row or column, say B8 and C7, but only if the value in C7 is less than zero. If value in C7 is more than zero need the cell to equal the value in B8 |
#3
|
|||
|
|||
add cells conditionaly not in continuous row or column
something like this =IF(C7<0,B8+C7,B8) -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=484172 |
#4
|
|||
|
|||
add cells conditionaly not in continuous row or column
Try this:
=B8+MIN(C7,0) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "loganinc6" wrote in message ... I need to add two cells not in a continuous row or column, say B8 and C7, but only if the value in C7 is less than zero. If value in C7 is more than zero need the cell to equal the value in B8 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
how can i fill blank cells in column with abc while the right col. | Excel Discussion (Misc queries) |