| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell selection and IF with multiple resutls
Hi all,
Is it possible in excel to do teh following 1- move the selection to a new location based on a certain criteria? for example, IF(A1=C4 Then move the cell selection to D4) 2- make an IF statement with multiple results...for example, =IF(A1=A3, 100 AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3, Then the current cell should be 100 and the cell next to it should be 200, and the cell next to that one should be 300...and so on... Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple cell selection | Excel Discussion (Misc queries) | |||
| How do I change the color for cell selection in excel? | New Users to Excel | |||
| Multiple cell selection | Excel Discussion (Misc queries) | |||
| Change Cell background color by selection | Excel Worksheet Functions | |||
| Getting a chart to stop if the formula resutls in a blank cell | Excel Worksheet Functions | |||
Threaded Mode
