In C4, type =IF(B3=0,"N/A")
But you don't say what you want if it does NOT = 0.

*******************
~Anne Troy

www.OfficeArticles.com


"CA user" <CA wrote in message
...
Is it possible to have a formula in one cell input data into another cell?

For example, if I want my formula in B3 to read if B3 equals zero then C4
will automatically be inputed with N/A.

If is possible, how would you write the formula?

Thanks for the Help!