Silver Fox
New Member
- Joined
- Mar 11, 2005
- Messages
- 6
I've got a workbook that collects data for food wastage tracking Breakfast, Lunch, Supper (using a standard price for each i.e. £1, £1.50, £2.00) as the data entry cells - that bit's OK.
As the data is entered daily it means that I've got cells that have a manual entry, which means that if the costs change, each cell has to be manually changed.
What I was hoping was that I could use the IF THEN statement, something like this.
In the first instance of a change in Breakfast cost I would enter the new cost in the first cell i.e C2, I was then looking to automatically update all the other 'Breakfast' cells using =IF(C2,2.5,THEN,C7,C12,C20 etc ...), in a blank cell.
Apologies if I have not explained the problem clearly, but any help/alternative suggestions on this would be appreciated
As the data is entered daily it means that I've got cells that have a manual entry, which means that if the costs change, each cell has to be manually changed.
What I was hoping was that I could use the IF THEN statement, something like this.
In the first instance of a change in Breakfast cost I would enter the new cost in the first cell i.e C2, I was then looking to automatically update all the other 'Breakfast' cells using =IF(C2,2.5,THEN,C7,C12,C20 etc ...), in a blank cell.
Apologies if I have not explained the problem clearly, but any help/alternative suggestions on this would be appreciated
