#if #and

  1. W

    HELP finding first Date of Clients

    Hi Everyone, I am trying to figure out how to find out when a client on my clientele list first visited our shop. Below is a sample table to give you an idea of what the clients list would look like and the date format that I am currently using. ABCDEFGHI1Client NameDatePaymentUnique...
  2. jclegg42002

    Using IF statement > 0 to copy data from separate worksheet - Need help - Brain Fried

    So I am stuck and I know this has to be an easy fix... I have always used this forum (for years) because it actually has smart people running it! Could anyone help? Sheet1 contains the following data starting at row 9 (to row 80): Bid Unit Short Description Unit Qty Unit Rate (1) Total Long...
  3. T

    How to payout based on Net Income Range

    Hey Team! Im stuck on a excel problem. Wonder if someone could give me some advice? Its a simple scenario, but Im having trouble with the function. Lets say you are going to get paid out based on the performance if your company. So any net income over $425,000 but under $725,000 you get 100%...
  4. S

    Problem using IF and AND together in same formula

    Hi, I hope the image above isn't too small. The browser crashed when I tried pasting the section of Excel directly. You will see above that there are two different formulae - one that is simply asking the commissionable value column to return the lowest number between columns B and D, and to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top