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 [email protected]> wrote in message
news:[email protected]...
> 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!
Bookmarks