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