Possible And If Question

[Guest]

Hopefully someone can help me with this, I am trying to start an inventory
system from scratch for a restaurant. So far I have everything working except
for 1 thing, and its throwing me for a loop, so let me explain, and hopefully
someone has a fix.

I have things set up this way
Item/In/How Packaged/Out/Price per unit/Total/Shrinkage/Wk1/Wk2/Wk3/Wk4

In the price per unit, I would like to be able to type in the price the item
cost me for the current week, in week1. now if next week I input the price
again, in week2 and it is different, i would like that price to reflect in
the price per unit cell. I can get this accomplished, its when I go to week 3
and 4 that things fall apart. I tried an IF statement for the wk1-4 like i
said it will work for wk1 and 2, as soon as you go to put something in wk3 it
either doesnt change or 0 out the price per unit cell, instead of changing
the cell, if there is a change in price that week.
Can someone give me an idea on how to fix this please
Thanks
Frank R Morrison GM LS Steakhouse

 

[Domenic]

Try...

E2, copied down:

=LOOKUP(9.99999999999999E+307,H2:K2)

Hope this helps!