if formula?

  1. P

    If and statement?

    Hi All, I need help with a formula. I have many rows of data containing crime numbers in column a, start date in b, end date in c and address in column d. Some of these addresses will be victims more than once. As such, is there any way of finding out where the crime start date and end date is...
  2. J

    Looking up multiple values where one value is in a range band on a matrix

    <tbody> Weight From Weight To Weight Category Route 1 Route 2 Route 3 Route 4 Route 5 0 30 1 43 20 35 28 41 30.01 50 2 43 20 35 28 41 50.01 75 3 52 25 40 35 49 75.01 100 4 55 29 43 39 53 </tbody> Hi there, I’m trying to work out a formula to...
  3. M

    Combining an IF Statement with multiplication

    Greetings, I am trying to find a formula that will allow me to do the following: If the value in A1 = 'A' then multiply B1 by .2 If the value in A1 = 'B' then multiply B1 by .15 If the value in A1 = 'C' then multiply B1 by .1 Here is the formula that I have put together, based on my research...
  4. S

    Lookup formula HELP!!!

    Hi All! We are working on a sheet and want to pull data from sheet 2 based on the date entered on sheet 1 cell A1. The data is arranged on sheet 2 by date. Each cloumn is a different date containing either a staff name in the rows below or off. These are list across 31 columns. In each row...

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