Hey,
I've been following your videos for a few months now and using them pretty extensively. Now I've got an issue in Excel and I'm not sure what to search for, or if you even have a video for the problem. So I thought I would message you about it.
Basically I've got to do car maintenance to my car and I want to program an excel sheet so that every 3000 miles it tells me that I first need to get my oil changed soon, then I need to do it now.
That part I can actually do with an IF function, the problem comes in two parts, really. How do I tell Excel to do it every 3000 miles without writing out 3000, 6000, 9000, etc? And is there a way that I can put an X in a cell next to where I got my oil changed, and then Excel references back to that point, then starts again?
For example, if I said remind me at 3000 miles, then I went a little over to 3129 and put an X next to it, is there some way for Excel to understand that the next oil change shouldn't happen until 6129? Not only that, but for it to understand that just because the value is greater than 3000 that it doesn't need to say "Change your oil now" if I already have changed my oil.
There are other things I would like to add too, like rotating my tires every so many miles, when I should get new tires. And if possible to change my oil either three months out, or 3000 miles, which ever happens first.
I don't know if it's easier to reference other sheets in the same book, or to write it all on one, or what. But if you have an idea of how to help, or a set of videos I should go check out, it would be a big help!
My current IF function looks like this:
=IF(AND(B2>=2500, B2<2900),"Change Oil Soon", IF(B2>2900, "Change Oil Now",""))
I was hoping to write it and get an epiphany of how to write it so that when I do change my oil, I can note it in D2 with an X, and then that'll be the new starting point for Excel to reference. Basically what happens now is that I have Date, Odometer, Warning, and Done columns.
The other issue, like I said, would be to get the "Warning" column to potentially light up with various other warnings of when I need to do other maintenance on my car. Like "Change Oil Soon" or "Rotate Tires Soon" and so on and so forth.
I don't even know what to search for with this kind of a problem. I know it's probably a pretty advanced technique, though. Also, this is for use with an iPod Touch (DocumentsToGo) or an Android phone (not sure what the other program is called), and so the macro stuff and conditional formatting doesn't work.
However if that's the only way for it to work, then that's fine. I can at least get the numbers on my phone, and update the sheet that way, and then when I put it on the computer, it'll tell me on there what needs doing.
Thanks,
Josh
I've been following your videos for a few months now and using them pretty extensively. Now I've got an issue in Excel and I'm not sure what to search for, or if you even have a video for the problem. So I thought I would message you about it.
Basically I've got to do car maintenance to my car and I want to program an excel sheet so that every 3000 miles it tells me that I first need to get my oil changed soon, then I need to do it now.
That part I can actually do with an IF function, the problem comes in two parts, really. How do I tell Excel to do it every 3000 miles without writing out 3000, 6000, 9000, etc? And is there a way that I can put an X in a cell next to where I got my oil changed, and then Excel references back to that point, then starts again?
For example, if I said remind me at 3000 miles, then I went a little over to 3129 and put an X next to it, is there some way for Excel to understand that the next oil change shouldn't happen until 6129? Not only that, but for it to understand that just because the value is greater than 3000 that it doesn't need to say "Change your oil now" if I already have changed my oil.
There are other things I would like to add too, like rotating my tires every so many miles, when I should get new tires. And if possible to change my oil either three months out, or 3000 miles, which ever happens first.
I don't know if it's easier to reference other sheets in the same book, or to write it all on one, or what. But if you have an idea of how to help, or a set of videos I should go check out, it would be a big help!
My current IF function looks like this:
=IF(AND(B2>=2500, B2<2900),"Change Oil Soon", IF(B2>2900, "Change Oil Now",""))
I was hoping to write it and get an epiphany of how to write it so that when I do change my oil, I can note it in D2 with an X, and then that'll be the new starting point for Excel to reference. Basically what happens now is that I have Date, Odometer, Warning, and Done columns.
The other issue, like I said, would be to get the "Warning" column to potentially light up with various other warnings of when I need to do other maintenance on my car. Like "Change Oil Soon" or "Rotate Tires Soon" and so on and so forth.
I don't even know what to search for with this kind of a problem. I know it's probably a pretty advanced technique, though. Also, this is for use with an iPod Touch (DocumentsToGo) or an Android phone (not sure what the other program is called), and so the macro stuff and conditional formatting doesn't work.
However if that's the only way for it to work, then that's fine. I can at least get the numbers on my phone, and update the sheet that way, and then when I put it on the computer, it'll tell me on there what needs doing.
Thanks,
Josh
