| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set a value in multiple cells based on a condition
I am trying to set a value in several cells when a single condition is true.
For example, if A1 = B1, then I want to set all cells C3, D3, E3 and so on to a given value. For instance, when IF(OR(A1<0, B1<0) ... ), I want to set a bunch of cells to zero. (I realize I can put an IF in each of the target cells, but this seems there should be an easier way.) Many thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condition based on multiple cells | Excel Discussion (Misc queries) | |||
| Compulsory Cells based on Condition | Excel Discussion (Misc queries) | |||
| Sum Cells Based on Condition (2 problems) | Excel Worksheet Functions | |||
| Adding cells based on condition | Excel Worksheet Functions | |||
| Counting Across Multiple Ranges, Based on Condition | Excel Worksheet Functions | |||
Threaded Mode
