Help Me Please!!

  • Thread starter Thread starter Kim-Anh Tran
  • Start date Start date
K

Kim-Anh Tran

I have cell A6 is Sum of A1:A5; cell C5 has this " If(A6=0),1,"").
If A6 has value then C5 is blank for me to hand write what I need t
enter. How do I change my If statement so that it allow any entr
without deleting my formulas in that cell.
I am not a programer and I am learning on my own. So my ability i
limited! I only can write a few nested If statements and simpl
V-look-up. I would appreciate very much if you would help me out!
Thanks in advance!:
 
Hi
you can only have a formula OR a manual entered value in a cell. So you
can't have both in one cell
 
Thank you So much Frank for your quick reply! I really appreciated.
May I ask you this please? How do I get a blank line from the drop dow
list
 
Try this example set-up for Data Validation [DV]:

In Sheet1
-----------

Put in A2: Data1

Copy down to A11

This will fill A2:A11 with Data1, Data2 ... Data10

Select A1:A11, and name* this range as: MyList
(Note that the range A1:A11 intentionally includes one blank cell, i.e. A1)

*To name: select the range, then click inside the namebox,
i.e. the box with the drop arrow just to the left of the formula bar
Type the name: MyList and press Enter


In Sheet2
-----------

Select col A

Click Data > Validation > Settings tab

Under Allow: select List

Put in the box for Source: =MyList

Click OK

--

Now click on any cell in col A in Sheet2

You should see the DV drop list *with* a blank cell as the top "selectable"
option

--

For more info on Data Validation,
suggest you check out Debra Dalgleish's nice coverage at:

http://www.contextures.com/xlDataVal01.html
 
I want to reply yesterday but I don't know how to reply to Newsgroup a
you noted. I email post master for this question but I did not have an
reply yet. Or maybe I don't know where to go to check for his reply.
Your direction and link website you gave me were so helpful. I a
learning more stuff there.
Thank you so much, Max.:
 
Back
Top