Show me exactly what you want. Show me the "input" cell and the cell where
you want the result to be and the values that you want the result to be and
where the values are .

"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