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

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

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