true statements

I ran into a speed bump yesterday and today with a true or false statement from data in a single column containing a speed (see attached picture). Most, if not all, speeds are two digits in length; however, yesterday and today I had several speeds post in single-digit format (i.e., 3, 6, 8...

Hi everyone I wonder if formula will suit my simple need below? Thanks!! <tbody> Days Over due Less than 30 30-59 60-90 90-179 More Than 180 20 (i need a fomula here, say if it's true return "1") 80 Same as here </tbody>

Hey guys, Literally had no idea of what to put for the title of this one but here it goes. So in a separate column say column E I want a formula that returns "true" when the following condition is met: B1 occurs for the first time in a unit but not any other time unless the unit changes. Units...

Hi there, I am working with a spreadsheet that deals with construction costs that is giving me trouble. In this spreadsheet, I am given the total cost of construction as well as the start and end date for the project. My goal is to approximate (on a monthly basis) what the total spend per...