| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to move from cell to cell
I need to create a formula that looks at cell P6 and if < 0 does a
calculation, if P6 is equal to 0 it moves to cell Q6 and looks to see if it is 0 or not, if not then it creates a calculation then onto cell R6 etc. The calculation needs to be based on whatever the last cell is that is <0. P6 is the last cell <0 then use that otherwise move to the next cell. The formula needs to be applicable up to cell W6. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change move down one cell | Excel Discussion (Misc queries) | |||
| Move Cell Value to Right Using Formula | Excel Worksheet Functions | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| How to keep a cell ref in formula unchanged when the ref cell move | Excel Discussion (Misc queries) | |||
| How do I move from a cell containing the formula TO a different c. | Excel Worksheet Functions | |||
Threaded Mode
