If and Vlookup formula
 

OK..so here is my question, For eg. I have a store that sells 10 units
of fizzy drink for last week. I also need to calculate how many
potentially it would sell if it was out of stock for 4 days and these
number of stores could either trade 6 days a week or 7 days a week.

so how do i do the following in 1 equation??
* Calculate the daily sales for this item
* Calculate the potential sales using a vlookup to see whether
this store is a 7 day or 6 day trader???

please help...

thanks

If and Vlookup formula
 

=A1/num_days_in_stock*num_sales_days

--
__________________________________
HTH

Bob

"Gor_yee" wrote in message
...
OK..so here is my question, For eg. I have a store that sells 10 units
of fizzy drink for last week. I also need to calculate how many
potentially it would sell if it was out of stock for 4 days and these
number of stores could either trade 6 days a week or 7 days a week.

so how do i do the following in 1 equation??
* Calculate the daily sales for this item
* Calculate the potential sales using a vlookup to see whether
this store is a 7 day or 6 day trader???

please help...

thanks