![]() I have an item price list and if a particular cell gets updated I want to automatically record the date of change of that cell. ![]() I am trying to automatically capture and record the date of a cell's last change in value (date stamp). The following is the sort of thing (many variations) I have been trying but because I'm hopeless at formulas I'm not having any success Thanks =IF(C13=0,','SUM(C9-C8))OR,IF(C9,ISBLANK,',SUM(C9-C8). Looking at cell 'C11 ' in the attached worksheet, I currently have the formula =IF(C13=0,','SUM(C9-C8)) The reason for this is to make it look tidy by having blank cells until a calculation is needed, My problem is, If someone just comes in for the morning one day for instance 8am to 12 noon then they won't have lunch, but C11 will show -12:00 Can I put another formula into C11 to tell it not to deduct C8 from C9 until a time is put into C9.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |