OR and MAX

HI, I have Office 3565 MSO exell 32 bit on wndows 10 pro

i have sheet 1 with a listing on line 1 of my vehicle , a column for current miliage to  entered in B1, and an cell C1 to alert me if a need tire rotation is needed. This number will be every 10000 miles 

I have sheet 2 with a listing on line 1 of when these 10000 miles are for my car under different columsn, C2-10000, D3-20000, so on.

I wish to have a cell C1 on sheet 1 to  alert me to when maintencend is needed on my car. I will enter the current miliage into a cell B1, which would check sheet 2  chart of fuute miliage numbers. When the current miliage in Cell 1, Sheet 1,  comes with 1000 milies of the any of the numbers on sheet 2, an alert is given in cell C1, sheet 1, “rotate tires”. The fourmula count should stop at 0, and move on to the next column on sheet2 as my newer miliage is entered over time.

I am thinking =IF(Sheet2!ORC1:D1-Sheet1!B1, Max(0,<1000,”rotate”,””))

By: Steve

39 thoughts on “OR and MAX

  1. air jordan

    I would like to get across my passion for your kind-heartedness supporting people who need help on this important issue. Your special dedication to getting the solution along had been surprisingly powerful and has truly enabled women much like me to reach their aims. Your warm and helpful information indicates a whole lot to me and substantially more to my colleagues. With thanks; from each one of us.

  2. kobe 11

    I actually wanted to jot down a remark to be able to express gratitude to you for all the unique items you are showing at this site. My long internet search has at the end been compensated with good insight to write about with my visitors. I would express that we readers actually are very much blessed to exist in a great website with very many special professionals with interesting tips and hints. I feel rather fortunate to have discovered the webpage and look forward to really more pleasurable times reading here. Thanks again for a lot of things.

  3. Antonetta

    Hi, I do believe this is an excellent blog. I stumbledupon it 😉 I may revisit
    once again since i have bookmarked it. Money and freedom is the
    best way to change, may you be rich and continue to help other people.

  4. air max 270

    I would like to express my thanks to you just for bailing me out of this predicament. Because of researching through the world-wide-web and coming across basics which were not pleasant, I was thinking my entire life was done. Being alive without the presence of strategies to the difficulties you’ve resolved as a result of your entire short post is a crucial case, and the ones that might have in a negative way affected my career if I had not noticed your web site. Your good training and kindness in dealing with all things was priceless. I am not sure what I would’ve done if I had not come upon such a step like this. I can also at this point look ahead to my future. Thanks so much for your high quality and amazing help. I will not be reluctant to suggest the website to any person who should receive direction on this matter.

  5. jordan retro

    My husband and i were really fulfilled that Albert managed to round up his researching because of the ideas he obtained from your own web pages. It is now and again perplexing to simply always be giving away information and facts which often people today have been making money from. We do know we need you to give thanks to because of that. All of the illustrations you have made, the simple website navigation, the relationships your site help to promote – it is most fantastic, and it is leading our son and our family reckon that that content is excellent, and that’s tremendously mandatory. Thanks for all!

  6. jordan shoes

    My spouse and i ended up being absolutely happy when Louis could do his survey from the ideas he received out of the weblog. It is now and again perplexing to just happen to be giving out secrets and techniques that many some people have been making money from. Therefore we keep in mind we’ve got you to be grateful to for that. All the illustrations you’ve made, the simple blog menu, the relationships you will assist to instill – it’s all sensational, and it is assisting our son in addition to the family reason why this theme is entertaining, which is certainly tremendously fundamental. Many thanks for the whole lot!

  7. supreme hoodie

    I really wanted to write a simple message so as to express gratitude to you for all of the fabulous ideas you are writing at this website. My considerable internet lookup has at the end of the day been recognized with professional points to go over with my pals. I would express that we visitors actually are really endowed to dwell in a fine network with very many awesome individuals with very helpful techniques. I feel truly happy to have encountered the web pages and look forward to some more cool times reading here. Thanks once more for all the details.

  8. kobe shoes

    I and my guys appeared to be following the excellent tips and hints located on your website and then immediately developed an awful feeling I had not thanked the web site owner for those secrets. All the boys were definitely for that reason glad to read all of them and already have in truth been taking pleasure in these things. Thanks for simply being well kind as well as for using certain very good issues millions of individuals are really desirous to understand about. My personal sincere regret for not expressing gratitude to sooner.

  9. nike air max

    I and also my friends appeared to be looking at the good strategies from your web page and so immediately I got an awful feeling I never thanked the web site owner for those techniques. Those boys had been stimulated to read through them and already have certainly been using those things. Thanks for truly being well accommodating and then for selecting this kind of superb useful guides millions of individuals are really desperate to be aware of. Our own honest apologies for not saying thanks to you earlier.

  10. golden goose outlet

    Thank you for all your valuable labor on this website. Ellie takes pleasure in getting into investigations and it’s simple to grasp why. Most of us hear all relating to the compelling tactic you make important strategies via this website and attract response from other people on the topic and our favorite girl is discovering a lot of things. Take pleasure in the rest of the year. You’re carrying out a great job.

  11. tinyurl.com

    great issues altogether, you just gained a
    logo new reader. What may you suggest in regards to your submit that you simply made a few days ago?
    Any positive?

  12. kd 11

    I wanted to compose a quick note to be able to say thanks to you for all of the awesome secrets you are giving out at this site. My rather long internet search has at the end of the day been compensated with pleasant suggestions to go over with my relatives. I would state that that we visitors are very lucky to be in a magnificent site with many lovely individuals with interesting techniques. I feel extremely privileged to have used your website and look forward to so many more pleasurable times reading here. Thanks again for everything.

  13. yeezy boost 700

    I want to express my appreciation to this writer just for rescuing me from this crisis. Because of looking out throughout the internet and getting views that were not pleasant, I assumed my entire life was over. Living minus the solutions to the difficulties you have fixed all through your main blog post is a serious case, and ones which might have adversely damaged my career if I had not encountered your web page. Your actual know-how and kindness in dealing with all the stuff was excellent. I don’t know what I would’ve done if I hadn’t come across such a point like this. It’s possible to at this moment look forward to my future. Thanks very much for this specialized and amazing help. I won’t think twice to propose your web blog to any person who would need support about this topic.

  14. offwhite

    I intended to draft you this bit of note so as to say thanks a lot the moment again with your wonderful guidelines you’ve shown above. It was certainly shockingly open-handed of you to allow openly precisely what some people might have advertised as an e-book in order to make some profit for their own end, even more so now that you might well have done it in the event you desired. The strategies as well worked to become fantastic way to be sure that someone else have the identical dreams like mine to grasp way more when it comes to this condition. I think there are thousands of more enjoyable sessions up front for many who read your blog.

  15. goyard wallet

    A lot of thanks for each of your effort on this web site. Betty enjoys getting into investigations and it is simple to grasp why. A number of us learn all about the compelling means you present powerful tips and tricks through your blog and in addition strongly encourage contribution from other people on that subject matter plus my princess is certainly starting to learn a great deal. Take pleasure in the rest of the year. You’re the one carrying out a fabulous job.

  16. coconut oil

    Hmm is anyone else encountering problems with the pictures on this blog loading?
    I’m trying to find out if its a problem on my end or if it’s the blog.
    Any feed-back would be greatly appreciated.

  17. kyrie irving shoes

    I wish to show my appreciation for your kindness supporting all those that actually need assistance with the area of interest. Your very own commitment to getting the message throughout had been unbelievably invaluable and has without exception encouraged individuals much like me to get to their targets. This informative tips and hints entails a whole lot to me and somewhat more to my peers. Thanks a lot; from all of us.

  18. Bernard Kratzer

    Aw, this was a really nice post. In idea I would like to put in writing like this additionally ? taking time and actual effort to make a very good article? but what can I say? I procrastinate alot and by no means seem to get something done.

  19. ps4 games

    You actually make it appear really easy along with your presentation however I find this topic to be
    really one thing which I believe I might by no means understand.
    It sort of feels too complicated and very vast for
    me. I’m looking forward in your subsequent
    publish, I’ll attempt to get the grasp of it!

  20. ps4 games

    I have been surfing online more than 2 hours today, yet
    I never found any interesting article like yours. It’s pretty worth enough for
    me. In my view, if all webmasters and bloggers made good content as you did, the net will be much
    more useful than ever before.

  21. jordan shoes

    I抎 need to examine with you here. Which isn’t one thing I normally do! I get pleasure from studying a put up that may make folks think. Additionally, thanks for permitting me to comment!

  22. quest bars cheap

    Its like you read my thoughts! You seem to know so much
    about this, like you wrote the guide in it or something.
    I think that you just could do with a few p.c. to pressure the message house
    a little bit, however other than that, that is wonderful blog.
    A fantastic read. I will certainly be back.

  23. jordan shoes

    Once I originally commented I clicked the -Notify me when new feedback are added- checkbox and now each time a remark is added I get 4 emails with the same comment. Is there any method you’ll be able to take away me from that service? Thanks!

  24. quest bars cheap

    Heya i’m for the first time here. I found this
    board and I in finding It really helpful & it helped me out
    much. I am hoping to offer one thing back and help others like you aided me.

  25. birkin bag

    This website can be a walk-via for the entire info you wanted about this and didn抰 know who to ask. Glimpse right here, and you抣l definitely discover it.

  26. adidas superstar shoes

    Can I simply say what a aid to seek out someone who really knows what theyre talking about on the internet. You positively know the best way to bring a problem to light and make it important. More people have to learn this and perceive this aspect of the story. I cant imagine youre no more widespread since you definitely have the gift.

Comments are closed.