=IF(A1="Y",C2,D2). Excel evaluates this as: if a1 = "y", return the value in
cell C2 else return the value in cell D2.

If you use =IF(A1="Y",B2=C2,B2=D2) Excel evaluates this as: if a1 ="y",.
then evaluate b2=c2 (true, false?) and if a1 is not = "y", then evaluate
b2=d2 (true, false?) and returns the appropriate true or false.

"Les G" wrote in message
...
I want to try something like IF(A1="Y",B2=C2,B2=D2), but I get FALSE in the
'input cell.. not exact formula being used, but I hope you get the gist

"Don Guillett" wrote:

Did you look in the help index for IF?
in cell b2
=if(a1="x","Y","")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Les G" wrote in message
...
I am fairly clued up with VB, but want to try cut down using VB when
designing spreadsheets... Is it possible to have a function (e.g. If
function) post a result into an alternative cell dependant an the value
in
the 'input' cell?
i.e. If A1 = X value then B2 = Y value