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.

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.


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

In cell C18, type

=IF(D18>0,"7480-8900","")

--
HTH

Bob Phillips

"khan" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

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

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)

--
HTH

Bob Phillips

"khan" <[email protected]> wrote in message
news:[email protected]...
> do u know how to oassword protect few cells on the work sheet instead
> of the whole sheet.
>