if calculations

  1. A

    How do I put the if function inside the lookup? - Daily Routine sheet

    I have a sheet - daily routine which has two columns: activity and time as shown here | Activity | Time | |----------------------|----------| | Sleep ? | 6:00 am | | Toilet ? | 6:15 am | | Get ready for gym ?‍♂️ | 6:30 am | | Exercise ? |...
  2. Z

    Assign the right cell/reference

    Hi, I have below table and what I need is to assign the right grp number when the condition is met. The current formula is =IF(OR(A2<=E2,A2>=F2),G2, IF(OR(A2<=E3,A2>F3),G3, IF(OR(A2<=E4,A2>=F4),G4, IF(OR(A2<=E5,A2>=F5),G5, IF(OR(A2<=E6,A2>=F6),G6, IF(OR(A2<=E7,A2>=F7),G7...
  3. T

    How to convert this conditional excel formula to VBA code ??

    Hello All, I've got a perfectly working Macro assigned to a button to copy paste the contents from one sheet (Designed like a form) to another sheet (Master database - Locked and Protected). This workbook will be shared with many people to fetch data from each. Now, I want my user not to leave...
  4. P

    How do you key a number in one cell that automatically puts a number in another cell?

    I'm trying to set up a worksheet that when you put a rating in one cell it automatically puts a factor in the cell underneath. What I'm trying to achieve Cell D7 - Rating cell that has a dropdown with the numbers 1, 2, 3, 4, 5 Cell E7 - Factor cell that relates to the number put in D7 being: 1...
  5. L

    Help with Commission spreadsheet so it will compute by month

    <tbody> Active/Inactive Customer Last Name Customer First Name Insurance Co PolicyType Policy # Written Date Effective Date Renewal Date Policy Pays Every Premium Amount Net Commission Active Doe John Ins ABC Auto 123 02/02/2013 02/07/2013 08/07/2013 6 Months 500.00 60.00 Active Smith...

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