Question about Excel (SS8SATAS5128400R)
i want to make a cell which is non-deletable in excel
plz any body can help me?
If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.
Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.
Posted on Jun 16, 2008
Tips for a great answer:
IF condition is “=IF(C6>6000,0.15%*(C6-6000),0)”
C6>6000 is your logical condition
0.15%*(C6-6000) would be the value if your logical condition
is TRUE, and
0 would be the value if your logical condition is FALSE.
IF condition is “(IF(C6>30000,0.3%*(C6-30000)))”
C6>30000 is your logical condition
0.3%*(C6-30000) would be the value if your logical condition
is TRUE, and
? would be the value if your logical condition is FALSE.
You are missing the value if it is FALSE.
be of some help/idea. Post back how things turns up or should you need
Good luck and kind regards.
Oct 26, 2007 | Excel (SS8SATAS5128400R)
Jul 12, 2008 | Excel (SS8SATAS5128400R)
May 22, 2008 | Excel (SS8SATAS5128400R)
Jan 25, 2008 | Network Storage Systems
90 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: