Getting value from one cell and put in another

[parteegolfer]

I am pulling my hair out trying to figuire out this problem.


In cell X1 I have a formula:
If(B38="",I39="LABOR","") - but I get a "False"message

Can someone help!

[zbor]

Because you write formula wrong... What do you want to do?

Edit: I assume you want in I cell write =IF(B38="","LABOR","")

[GuruWannaB]

If(B38="",I39="LABOR","")

I think I understand what you want to do...make I39 = LABOR IF b38= "". If so...put this formula in the cell I39

Please Login or Register  to view this content.

you can't instruct a formula to modify the data in another cell....but you can instruct the formula to change the value of the cell the formula is in....thus why the I39="LABOR is causing a problem with your formula.

[parteegolfer]

the problem is if I put this formula into I39, I wont be able to insert misc number if B38 is false.

that is why I want to put the formula in another cell(X1). This way if it is true, it will put "Labor" in cell I39 if not it will leave it blank so I can manually enter data without erasing the formula.

[zbor]

It doesn't work that way.

You need macro for that.

[parteegolfer]

Any suggetions with the macro?

[Shijesh Kumar]

Whats you exact requirement .. can you explain in detail