if a and b then enter c

Hi I am working on a spreadsheet that will calculate what hour a store should close based upon it's last hour or sales. The logic works like this: a) If a store has greater than $100 of sales in it's last hour, close one hour later. b) If a store has less than $50 of sales in it's last hour...

Hello, We have a simple break list at work. I spent a lot of time making a better one, but the manager said it's too complicated. I want to improve the one we have now at least a little. (screenshot attached) In this break list, when you click on a cell under the "status" column - you have 4...

I am constructing a multicurrency investment portfolio. Apart from the usual entry requirements like date;buy or sell; name of investment; quantity; currency of investment; value etc. I need to look up the exchange rate on the date of the transaction. How would I write a formula to extract the...