Hi, i have no idea how to title it, i will just explain what i am trying ot achieve.
Cell A4 value is either a number or "N/A"
Cell A5 has a reference to cell A6 in Sheet 2 which has a value of 100
I would like to make A5 value change according to the value of A4
IF A4 is "N/A" then return "N/A"
IF A4 is number then A5 will return the value of A6 in sheet2
I use the following formula,
=IF(A4="N/A", "N/A", =Sheet2!$A$6)
And apparently this is not working.
Appreciate any helps and thank you in advance
Cell A4 value is either a number or "N/A"
Cell A5 has a reference to cell A6 in Sheet 2 which has a value of 100
I would like to make A5 value change according to the value of A4
IF A4 is "N/A" then return "N/A"
IF A4 is number then A5 will return the value of A6 in sheet2
I use the following formula,
=IF(A4="N/A", "N/A", =Sheet2!$A$6)
And apparently this is not working.
Appreciate any helps and thank you in advance