You can do just that. Put the formula in the cell where you want the answer
to be!!!!

"Les G" wrote in message
...
Thanks Tyro...
That is logical but a pity, because if you could have returned a result
from
one of the cells as apposed to the 'True / False', it would have meant
that I
could iterally program from within excel without the downfalls of sending
excel spreadsheets to my users with VBA modules / macros..

"Tyro" wrote:

=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