Excel Question..

[rlporter]

I have a 2 part question.

1. Is there a way to lock formula's in a field so the delete key will not delete the formula?

2. Is there a way to write a formula so if 2 fields equal each other the value of 3 other fields will be 0?

I have a small parts quantity spread sheet. I have the following fields:

Part Number
Part Description
Starting Inventory
Parts Used
On Order
Received
Total Parts

If Starting Inventory and Total Parts is equal, the value of Parts Used / On Order / Received will automatically change to a 0.

Thanks for any help..

 

[xlbo]

1. Yes - but you have to PROTECT the sheet
2.Have a look at the IF and AND functions

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question