if or and statements

  1. L

    A formula that highlights either age or mileage of a vehicle, whichever comes first

    I have a challenge, if anyone is kind enough to assist. I can probably put a formula together for 1 condition, but the mix of mileage/date has be stumped! I am attempting to create a spreadsheet for my boss that tells him if a vehicle is due a service. (I have been in this job 1 month and I...
    • les361800
    • Thread
    • condition formula formula & macro if or and statements if satement mileage calculator service date
    • Replies: 2
    • Forum: Excel Questions
  2. Z

    I need the right formula

    <tbody> Questions 2016 Favorability Standard Deviation 2017 Favorability Standard Deviation 2018 Favorability Standard Deviation Result Q1 66.5% 1.15...
    • zinah
    • Thread
    • 50% deviation if and formulas if or if or and statements
    • Replies: 3
    • Forum: Excel Questions
  3. I

    Help with If Function

    I may be wrong, but I'm thinking I need to write an if function to accomplish my goal but can't seem to figure it out on my own. I have 13 columns and 26 rows. Rows list names of staff and columns list the months of the year. For each staff name listed on each row, when "yes" is entered into...
  4. F

    Need help with IF formulas...

    Hi! I have a problem with my formula. I want to make this into formula form. But I am having difficulty because the formula will be too long if I try to fix it using an OR statement. Is there any way I could set a range? In this current set up, the result value is always 1, I want it to be FALSE...

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