If and Vlookup formula

G

Gor_yee

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP with multiple lookup_value's 3
If Formula - Desperate for help 3
Multiple if and Vlookup 3
Averaging Formula 8
Month calculation from cost for a business plan - please help 3
Calculating bonuses - but not a VLOOKUP or CEILING? 6
Commission formula 6
Need help creating a simple (?) SUM formula! 4

Top