Need to conditionally replace a cell...

[ExMainframer]

with the value in another cell.

I am putting together a spreadsheet that will be a time sheet for the various tasks that a worker does. Each of the tasks has a payment amount associated with the task. I would like the worker to simply enter an X in a cell to indicate that s/he performed the task. Behind the scene I want to then replace the X with the actual pay which is stored in another cell.

Thanks,

Pete

[AlfD]

Hi!

Assume the payment is to be stored in G1
Assume the amount of the payment is stored in F1
Assume the X is to be placed in A1

Then put this in G1:

=if(A1=X,F1,"")

If there is a likelihood the user will use x or X indiscriminately,

=if(OR(A1="x",A1="X"),F1,"")

Alf

[ExMainframer]

I am hoping to be able to actually REPLACE the X with the payment amount.

If I have a cell (A1) that represents, say, headlight replacement, and it pays $5.60, I would like to have the mechanic enter an X in A1 and have the spreadsheet recognize the X in A1 and replace the X with the $5.60 which is in B1.

So A1 would start empty, the mechanic would put an X in it, and the spreadsheet would replace the X with the actual payment amount of $5.60 which is in cell B1.