| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I evaluate A1 from cell A2 and place a value into A3?
This is basically what I am trying to do from cell A2;
=IF(A1=1, Cell A3=2, Cell A3=99) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I evaluate A1 from cell A2 and place a value into A3?
You can't set a cell from another cell.
Use this in A3 =IF(A1=1,2,99) -- __________________________________ HTH Bob "RMar10" wrote in message ... This is basically what I am trying to do from cell A2; =IF(A1=1, Cell A3=2, Cell A3=99) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I evaluate A1 from cell A2 and place a value into A3?
I use that same cell (A3) for the 'Cell Link' in a drop down list. I can't
put a equation in it. "Bob Phillips" wrote: You can't set a cell from another cell. Use this in A3 =IF(A1=1,2,99) -- __________________________________ HTH Bob "RMar10" wrote in message ... This is basically what I am trying to do from cell A2; =IF(A1=1, Cell A3=2, Cell A3=99) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I evaluate A1 from cell A2 and place a value into A3?
Hi,
If A3 is the cell link for your dropdown list, why do you need to coerce it to read 99 if A1=1? Dave "RMar10" wrote: I use that same cell (A3) for the 'Cell Link' in a drop down list. I can't put a equation in it. "Bob Phillips" wrote: You can't set a cell from another cell. Use this in A3 =IF(A1=1,2,99) -- __________________________________ HTH Bob "RMar10" wrote in message ... This is basically what I am trying to do from cell A2; =IF(A1=1, Cell A3=2, Cell A3=99) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I evaluate A1 from cell A2 and place a value into A3?
If another condition exists, I need to override what was manually selected
from the dropdown list. "Dave Curtis" wrote: Hi, If A3 is the cell link for your dropdown list, why do you need to coerce it to read 99 if A1=1? Dave "RMar10" wrote: I use that same cell (A3) for the 'Cell Link' in a drop down list. I can't put a equation in it. "Bob Phillips" wrote: You can't set a cell from another cell. Use this in A3 =IF(A1=1,2,99) -- __________________________________ HTH Bob "RMar10" wrote in message ... This is basically what I am trying to do from cell A2; =IF(A1=1, Cell A3=2, Cell A3=99) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I evaluate A1 from cell A2 and place a value into A3?
Always do that in a separate cell and use that cell for further processing.
-- Kind regards, Niek Otten Microsoft MVP - Excel "RMar10" wrote in message ... If another condition exists, I need to override what was manually selected from the dropdown list. "Dave Curtis" wrote: Hi, If A3 is the cell link for your dropdown list, why do you need to coerce it to read 99 if A1=1? Dave "RMar10" wrote: I use that same cell (A3) for the 'Cell Link' in a drop down list. I can't put a equation in it. "Bob Phillips" wrote: You can't set a cell from another cell. Use this in A3 =IF(A1=1,2,99) -- __________________________________ HTH Bob "RMar10" wrote in message ... This is basically what I am trying to do from cell A2; =IF(A1=1, Cell A3=2, Cell A3=99) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Evaluate value of cell to determine fill upwards | Excel Discussion (Misc queries) | |||
| evaluate cell value with sheet name | Excel Worksheet Functions | |||
| Can Excel evaluate one cell and return the information in another? | Excel Discussion (Misc queries) | |||
| How do I evaluate a row of cells for a character in each cell? | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Hybrid Mode
