| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas
How can I programme excel so that if Column A is filled in for a value then
it will ignore any values in Column B? |
|
#2
|
|||
|
|||
|
Hi
and what do you want to do with this information afterwards? -- Regards Frank Kabel Frankfurt, Germany GBH99 wrote: How can I programme excel so that if Column A is filled in for a value then it will ignore any values in Column B? |
|
#3
|
|||
|
|||
|
Hi,
In C1,put =if(A10,A1,B1) and copy this down in column C. Thank you, K.S.Warrier "Frank Kabel" wrote: Hi and what do you want to do with this information afterwards? -- Regards Frank Kabel Frankfurt, Germany GBH99 wrote: How can I programme excel so that if Column A is filled in for a value then it will ignore any values in Column B? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas not working | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
| Tricky formulas needed | Excel Worksheet Functions | |||
Linear Mode
