Excel Help
Solved/Closed
Amber1984
Posts
3
Registration date
Wednesday March 11, 2009
Status
Member
Last seen
March 17, 2009
-
Mar 12, 2009 at 08:08 AM
Amber1984 Posts 3 Registration date Wednesday March 11, 2009 Status Member Last seen March 17, 2009 - Mar 17, 2009 at 07:13 AM
Amber1984 Posts 3 Registration date Wednesday March 11, 2009 Status Member Last seen March 17, 2009 - Mar 17, 2009 at 07:13 AM
Related:
- Excel Help
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Screenshot in excel - Guide
4 replies
fedexpro
Posts
20
Registration date
Wednesday September 3, 2008
Status
Member
Last seen
April 15, 2009
6
Mar 13, 2009 at 02:49 AM
Mar 13, 2009 at 02:49 AM
hi,
try this link to see if it can help you:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPT9,M1
this include a book where you can find almost all the formulas used in excel.
hyope it helps you.
try this link to see if it can help you:
https://books.google.mu/books?id=IFxnNpHFEOQC&dq=excel+formulas&printsec=frontcover&source=in&hl=en&ei=QaefSfPXNJz47AON2bXCCg&sa=X&oi=book_result&ct=result#PPT9,M1
this include a book where you can find almost all the formulas used in excel.
hyope it helps you.
epsiman
Posts
307
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
162
Mar 13, 2009 at 04:20 AM
Mar 13, 2009 at 04:20 AM
https://www.usd.edu/ctl/self-paced-tutorials this link should help you!
Amber1984
Posts
3
Registration date
Wednesday March 11, 2009
Status
Member
Last seen
March 17, 2009
Mar 13, 2009 at 03:32 PM
Mar 13, 2009 at 03:32 PM
Hey guys,
I tried both those links and wasnt able to find something that would help. I feel dumb, thanks for trying. I don't know I thought it was simple, I guess its not.
Thanks again,
Amber
I tried both those links and wasnt able to find something that would help. I feel dumb, thanks for trying. I don't know I thought it was simple, I guess its not.
Thanks again,
Amber
Try this- Dates will be in cells A1, A2, A3, & A4
Put this formula in Cell A5: =COUNTBLANK(A1:A4)
Put this formula in Cell A6: =IF(A5=0,"All Complete", "Need More")
Or, they can be combined into one cell =IF(COUNTBLANK(A1:A4)=0,"All Complete", "Need More")
Alternatively, you can use COUNTA to test for the number of cells that are filled in and change the zero to the number of cells monitored and then reverse the message alternatives.
If you use conditional formatting for Cell A6 you can also change the color of the text to make the status more noticeable.
I'm not sure I understand the second question, but I think the Count functions can be applied there somehow.
Put this formula in Cell A5: =COUNTBLANK(A1:A4)
Put this formula in Cell A6: =IF(A5=0,"All Complete", "Need More")
Or, they can be combined into one cell =IF(COUNTBLANK(A1:A4)=0,"All Complete", "Need More")
Alternatively, you can use COUNTA to test for the number of cells that are filled in and change the zero to the number of cells monitored and then reverse the message alternatives.
If you use conditional formatting for Cell A6 you can also change the color of the text to make the status more noticeable.
I'm not sure I understand the second question, but I think the Count functions can be applied there somehow.
Amber1984
Posts
3
Registration date
Wednesday March 11, 2009
Status
Member
Last seen
March 17, 2009
Mar 17, 2009 at 07:13 AM
Mar 17, 2009 at 07:13 AM
HI RZ,
Thank you so much you just saved a whole lot of time,
Thanks again,
Amber
Thank you so much you just saved a whole lot of time,
Thanks again,
Amber
