Formula Help

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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
#VALUE! - how to get rid of it? 2
Excel Need Countifs Formula Help 0
formula is too long error 3
I need a formula 2
Formula Help required! 5

Back
Top