if coum 2 has vale then populate colum1

K

khan

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.
 
D

Duke Carey

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(D18>0,"7480-8900","")

The last portion of that, i.e., "" , says that if D18 is <=0, then C18's
value is an empty string.
 
K

khan

do u know how to oassword protect few cells on the work sheet instead
of the whole sheet.
 
B

Bob Phillips

What you do is unlock the worksheet (Format>Protection),
then select the cells to protect
then lock those cells(Format>Protection)
and then protect the sheet (Tools>Protection)
 
Top