complex if formula

Hello Experts, I need your help to automate a long manual activity which takes allot of time. Every week I have received stock transfer requests of 500 line items from LHR and ISB to replenish the stock from KHI which is our central Warehouse to feed both locations. Please see below table with...

Hello geniuses, Imagine the table below is longer with more variables. Each color is a company. Number is dollars earned. There are three different businesses: A, B, and C. I'm trying to take the full sum of each company's book of business, but classify them by the more dominant business. So if...

Hi there, Im trying to create some formulas so me and my colleagues can work out our bonus. It comes in two parts - Team and Individual accelerators. Now Im able to get the individual accelerators to work to a certain point then all I get is "FALSE" and I can get the Team bonus to only work...

I'm getting all twisted up in my logic for the following situation, or maybe this can't be done with a simple formula.... Thank you! In B3, add +1 for each year up to 5 that company has had sales and they have not declined; also add +1 for each year company’s sales have increased. A...

Hello, After so many years of saying that there was no need to use VBA, I think I've reached my breaking point. Any help will be greatly appreciated! :-) Being a beginning at VBA, can someone please assist? I am trying to calculate the sum of a string of products under certain limitations...

Hi All, Please can someone help me in excel 2007, I need to create a formula to do the following: if the price falls between £0 - £150 then to add £30 onto the price, (e.g £100 will add £30 = £130) or if it is >£150 but <=£200 then add £50, or if is >£200 but <=£300 then add £80 or if it is...