Search results

Gotcha. Okay, I have a decimal symbol (.) in the aforementioned spot.

Where can I go to determine that? I see it as 1.5. Sorry for the inconvenience. I didn't reformat anything. Thanks.

@SirJB7-ah yes, my apologies. See uploaded file, same as my previous post. Thank you PaulF. Makes sense.

In the spreadsheet (see the Tab "Sheet1"), I have what I thought was a pretty simple table. I am evaluating the ratios in all the highlighted cells to see if they are <1.5. If they are less than 1.5, then the segment is reliable (YES), if it's > 1.5, then it's a NO. For some reason, I cannot...

Worked like a charm! For my own personal edification, how is it using the MEDIAN function? I know what the median is but could you explain it's purpose here? Much appreciated!!!!!!!!!!!!!! G

Given the table, I have the following criteria (times in 24 hour): IF 6:00 to 10:00 AND weekday = Y THEN Category = 1 IF 10:01 to 16:00 AND weekday = Y THEN Category = 2 IF 16:01 to 20:00 AND weekday = Y THEN Category = 3 IF 06:00 to 20:00 AND weekday = N THEN Category = 4 There are no times...

Ah, I figured it out!!!! Thank you for your time. I really appreciate it! Greg

Thank you for the kind welcome! Ok, I looked at the post, however, I have the following question: if I decided to change the "Employee Code" from, let's say, 1 to 2, how does the sheet "refresh" itself to reflect the change? What about adding rows? I may have missed something, so I apologize...

Hello! I have a spreadsheet (single tab) with data arrayed as follows: Project Number Cost Completion Inspector Name 0001234 $78,000 9/9/2013 Tribble 0123344 $90,567 8/1/2014 Simmons 9900445 $43,000 7/23/2014 Simmons 4566723...