if=

Hi guys so I have a formula that needs to show 3 things as of today if Date is within a year ( of today) = Ok Date is within 30 days ( of today) = >30 daysDate has passed ( as of today) = Expired This is what I have and cant seem to get >30 days to...

Hello, I have a question on a chart that I am trying to build in excel. My goal is to find out if production on a machine is " on time to start date compared to the finish date, taking into consideration there is a " set up time and run time ". Columns: L=start date , M=finish date , N= set up...

Hi there, I am in the process of getting back to doing some more advanced things with Excel and it seems some of my knowledge has got rather rusty! What I am trying to do is create a function to look at a range of cells and evaluate based on 3 possible conditions, if all the cells have value A...

Alrighty, I have created a spreadsheet to portray the number of students coming into where I work, a writing tutoring lab, what their major is, what class they are here for, and what they worked on. From here, I would like to create a formula that will take my "X" and make it =1 so that I can...