| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if coum 2 has vale then populate colum1
if D18 0 then c18 =7480-8900
can any one help how to do that.I want 7480-8900 to be shown in D18 only if C18 has value 0. |
|
#2
|
|||
|
|||
|
You have stated your objective two different ways: in one you want to put a
value in C18, in the other the value goes into D18 Assuming it's to go in C18, then this formula should go in that cell (C18) =IF(D180,"7480-8900","") The last portion of that, i.e., "" , says that if D18 is <=0, then C18's value is an empty string. "khan" wrote: if D18 0 then c18 =7480-8900 can any one help how to do that.I want 7480-8900 to be shown in D18 only if C18 has value 0. |
|
#3
|
|||
|
|||
|
In cell C18, type
=IF(D180,"7480-8900","") -- HTH Bob Phillips "khan" wrote in message oups.com... if D18 0 then c18 =7480-8900 can any one help how to do that.I want 7480-8900 to be shown in D18 only if C18 has value 0. |
|
#4
|
|||
|
|||
|
do u know how to oassword protect few cells on the work sheet instead
of the whole sheet. |
|
#5
|
|||
|
|||
|
What you do is unlock the worksheet (FormatProtection),
then select the cells to protect then lock those cells(FormatProtection) and then protect the sheet (ToolsProtection) -- HTH Bob Phillips "khan" wrote in message ups.com... do u know how to oassword protect few cells on the work sheet instead of the whole sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Populate cells with a unit price | Excel Discussion (Misc queries) | |||
| REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
| getting multiple data to populate another worksheet | Excel Worksheet Functions | |||
| How to populate column with formula based on value in cell | Excel Worksheet Functions | |||
Linear Mode
