Change the data in one cell based on content of another.
 

I've had a memory lapse here. I need to change the value of one cell (user
input cell) based on the content of another cell. See the following:

Materials
# Item Unit Price Qty. Total

1 $0.00 0.00 $0.00
2 $0.00 0.00 $0.00
3 $0.00 0.00 $0.00
4 $0.00 0.00 $0.00

If no item is selected unit price will be $0.00 need Qty to revert to 0.00
as well.

Thanks in advance

Barry

Change the data in one cell based on content of another.
 

You could try using the IF Function.

Magnivy

"Barry" wrote:

I've had a memory lapse here. I need to change the value of one cell (user
input cell) based on the content of another cell. See the following:

Materials
# Item Unit Price Qty. Total

1 $0.00 0.00 $0.00
2 $0.00 0.00 $0.00
3 $0.00 0.00 $0.00
4 $0.00 0.00 $0.00

If no item is selected unit price will be $0.00 need Qty to revert to 0.00
as well.

Thanks in advance

Barry

Change the data in one cell based on content of another.
 

Hi Barry

Qty column cannot be user input, AND contain a formula that will cause
it to be 0 if Material is deleted.
It can only be one or the other and I guess user input of Qty wins out.

The formula in your Total column however, could be set as follows
=IF(A2="","",B2*C2)
So if there is nothing in A2, then there will be nothing in D2,
otherwise it will hold the value of Price * Qty.

--
Regards

Roger Govier


"Barry" .(donotspam) wrote in message
...
I've had a memory lapse here. I need to change the value of one cell
(user
input cell) based on the content of another cell. See the following:

Materials
# Item Unit Price Qty. Total

1 $0.00 0.00 $0.00
2 $0.00 0.00 $0.00
3 $0.00 0.00 $0.00
4 $0.00 0.00 $0.00

If no item is selected unit price will be $0.00 need Qty to revert to
0.00
as well.

Thanks in advance

Barry