In b1 you would need to put a formula

=if(A1=1,5,6)

The formula will go in the cell that displays the results - the cell that
will be affected.

--
Regards,
Tom Ogilvy

"alMandragor" wrote in message
...
For example:

If cell A1 equals 1, then cell B1 should have the value 5, otherwise B1
should be 6.

By setting a condition in A1, I am affecting B1. Is that possible?