| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if then clause in a cell
I believe i need to write a if then clause.
What i am trying to do is pretty simple in access, but in excel - i've been at it for days. Cells A3 to A10 always hold data. In cells D3 to D10 only one cell holds data, which is a number "1", the other cells are null. What i am trying to do is: If cell D4 = 1 then fill cell D12 with the value of cell A4, likewise if cell D7 = 1 then fill cell D12 with the value of cell A7. How do i do this and where would i pop the code? Just new to excel - but making good progress. --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if then clause in a cell
In D12:
=INDEX(A3:A10,MATCH(1,D3:D10,0)) "mikewild2000" wrote in message ... I believe i need to write a if then clause. What i am trying to do is pretty simple in access, but in excel - i've been at it for days. Cells A3 to A10 always hold data. In cells D3 to D10 only one cell holds data, which is a number "1", the other cells are null. What i am trying to do is: If cell D4 = 1 then fill cell D12 with the value of cell A4, likewise if cell D7 = 1 then fill cell D12 with the value of cell A7. How do i do this and where would i pop the code? Just new to excel - but making good progress. --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if then clause in a cell
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if then clause in a cell
Thanks.
How do i get around D12 giving #N/A error. Can it be changed to a "0" rather than give the error? The error occurs when there is no value in D3:D10 --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PERCENTILE with an IF Clause | Excel Worksheet Functions | |||
| IF clause for a range of cells | Excel Worksheet Functions | |||
| IF Clause | Excel Worksheet Functions | |||
| "Between" in an IF clause | Excel Discussion (Misc queries) | |||
| Where Clause Errors | Excel Programming | |||
Hybrid Mode
