ExcelBanter - cell links

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cell links (https://www.excelbanter.com/excel-worksheet-functions/210530-cell-links.html)

Dave

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

Dominik

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

All times are GMT +1. The time now is 05:26 AM.