Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell links
Help.. Cell A1 has a value of 400 in it. Cell A2 has the letter A.
In a seperate cell, I want to check cell A2, if it is the letter A, then I want to put the value in A1 in to my cell where I am doing my formula. -- cheers Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell links
=IF(A2="A",A1,FALSE)
"dave" wrote: Help.. Cell A1 has a value of 400 in it. Cell A2 has the letter A. In a seperate cell, I want to check cell A2, if it is the letter A, then I want to put the value in A1 in to my cell where I am doing my formula. -- cheers Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a way to show what each cell links to? | Excel Worksheet Functions | |||
cell links | Excel Worksheet Functions | |||
cell links | Excel Worksheet Functions | |||
cell links | Excel Worksheet Functions | |||
links in a cell | Excel Worksheet Functions |