Formula Help

M

Mike

In CH5:CH65 I have names, Now in CL5:CL65 i want to enter these names if
greater than THERE values=hours in CJ5:CJ65 by 28
 
S

Sheeloo

Where is the value which might be more than 28?

Enter this in CL5 and copy upto CL65
=IF(CJ5>28,CH5,"")
This will show names in CL5 if the value in CJ5 is more than 28 (blank
otherwise). You can adapt this to your need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min/Max need help 7
I Really need help with formula 1
I need help 3
Crating User Form to Add Names 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Use TODAY() function as the criteria in a SUMIF formula 1
Mail Merge Help 1
Grouping Names in Mail Merge 0

Top