Hi,
I think you should write this formula to Cell D3216 :
=IF(OR(B3216=1,C3216=1),A3216,"")
Which means : IF Cell B3216 OR Cell C3216 IS Equal to 1, Then Write the value
of cell A3216 IN Cell D3216, but if neither A or B is equal to 1 then write
Nothing ("") on Cell D 3216
Hope it helps...
[Sent from AXIS SilverBerry®]
-----Original Message-----
From: "[email protected]" <[email protected]>
Date: Mon, 04 Jan 2010 16:38:38
To: <[email protected]>
Subject: ]] XL-mania [[ If Function
Having trouble with =If function. My goal is to copy the value in cell A if
cell B OR cell C has a specific expression. In other words, if cell B or cell C
equals 1 then copy contents of cell A into cell D. Can anyone help me with the
proper syntax? Example; =IF(F3216=1,D3216) will return the contents of cell
D3216 if cell F3216=1 into the cell where the syntax is located. I want to
include a second (if cell =1) into the string.
