| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change value based on another cell's value
=IF(R1C3=0,0,SUM(R1C3:R20C3))
Also note that the use of sum for the product is redundant. A simple: =r1c1*r1c2 would suffice. HTH Kostis Vezerides |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| % change in the last two cells in a row | Excel Worksheet Functions | |||
| Resetting values based on change in cells of other column | Excel Discussion (Misc queries) | |||
| locking cells based on results at runtime | Excel Worksheet Functions | |||
| Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
| I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
Threaded Mode
