Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatic filling in cells in excel
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
Hi!
Is it possible to have a formula in one cell input data into another cell? No, it doesn't work that way. What you would do is have a formula in cell C4 that tests cell B3 to see if it equals zero. Formula in C4: =IF(B3=0,"N/A","") This formula has 3 parts (called arguments) to it: A logical test: B3=0 A value to return if the logical test is TRUE: "N/A" A value to return if the logical test is FALSE: "" Since you did not specify the value_if_FALSE argument, I assumed you might want the cell left blank if B3 does not equal zero. That's what the double quotes do: "". Also, an empty cell will evaluate to zero, so if cell B3 is empty: =IF(B3=0,"N/A","") Will evaluate to TRUE and return N/A. A more robust formula will test for both B3 not being empty and equalling zero at the same time: =IF(AND(B3<"",B3=0),"N/A","") Biff "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
Counting cells in Excel? | Excel Discussion (Misc queries) | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions |