Excel Help [Solved/Closed]

Report
Posts
3
Registration date
Wednesday March 11, 2009
Status
Member
Last seen
March 17, 2009
-
Posts
3
Registration date
Wednesday March 11, 2009
Status
Member
Last seen
March 17, 2009
-
Hello,


Ok am not that experienced with excel, so if any one can helo would be great. I have a huge spreadsheet and i am constantly updating it. My question is, is it possible to have a cell give me a value based on the the values og other cells. For example i will be entering dates on a row for each task preformed, and what i want to happen is have a cell say complete or something when all those dates have been entered. The other thing is on my spreadsheet there are 5 different jobs that are broken up by 10 tasks fo each job. Can I also do this task which auotmatically gives the value complete on the spreadsheet multiple times. Thank you so much in advance.

-Bye
Amber

4 replies

Posts
20
Registration date
Wednesday September 3, 2008
Status
Member
Last seen
April 15, 2009
6
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.
Posts
308
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
162
Posts
3
Registration date
Wednesday March 11, 2009
Status
Member
Last seen
March 17, 2009

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
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.
Posts
3
Registration date
Wednesday March 11, 2009
Status
Member
Last seen
March 17, 2009

HI RZ,

Thank you so much you just saved a whole lot of time,

Thanks again,
Amber