if and then

  1. H

    Help with a scheduling system

    Hello, I'm looking for a formula that would turn a cell a certain color (the intricate part is I need it to read a code from another formula where the name that will be placed which will be in a different spot everyday will look up a certain code like AA. If the name does not have an AA beside...
    • Holmes89
    • Thread
    • duplicate values if and then if and then function schedule schedule help schedule template staff
    • Replies: 1
    • Forum: Excel Questions
  2. R

    if and then using more than one cell

    How do i create if/then using multiple cells? For example, I have data that i want to compare from D50 to D55 and i want to create and if and then statement saying that if all the values from D50 to 55 are greater than a number, then it passes. I wanted to do this for multiple groups of cells...
  3. D

    Multiple If And Then VBA code

    Hi guys, New to the forum, and also pretty much a newbie when it comes to Formula/VBA for Excel. I'm trying to get some VBA code working (as I know I would be unable to do what I need with a formula, due to the size of it) but I'm not sure where to start. Basically, I'll lay it out logically...
  4. K

    Nested "IF AND THEN" - Need expert guidance please!

    I am struggling with a formula and have read (and benefitted) from some earlier threads. However, looking for the elegant solution that may not exist... I'm building a scheduler for a team of 200+ individuals. I have 50K rows of data with a large number of columns. I'm trying to build a...
  5. J

    If and then

    Hi there I wonder if anyone can help me with this. I need VBA code for: If Range(F2)greater or equal to 90000 and (H2) = 90000 the (J2) ="Gold' else if (F2) = smaller than 90000 but greater or equl to 70000 and H2 = 90000 the H2 = Silver Hope this makes sense and that someone can help me...

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