And if the user enters data in B1, or any two of A1, B1 & C1?

--
macropod
[MVP - Microsoft Word]
-------------------------

"Snake007" wrote in message ...
I would like to use a conditional statement and based on the condition move
the result of a formula to a blank cell.
Example: cells A1 , B1 , C1 are blank. If a person enters data in A1 a math
fuction is done and results are displayed in B1 and C1. However if the data
is entered in C1 a different math fuction is done and the results are
displayed A1 and B1.

Is this possible?