value changes

For now i have 2 spots that have a time stamp when text is entered/changed C19 changes text C20 is date stamp, same with C30 and C31 getting date stamp. C19 pulls its cell value from another place and updates (to the same value) every time the document is opened so i don't want that to change...

Here is an example data set - a series of cash flows A1: 0 A2: -50 A3: -25 A4: 50 A5: 80 A6: 100 I need the following... In the first cell (B1) I need to have the first year of cash flow regardless of whether the cell is < or > 0 In the next cells (B2) I need to have an...

Dear experts, I have random securities in column B with a respective value in column C. I want to calculate the profit I made if I sell the security. However, I only sell if the security in column B changes in the following row. Otherwise I hold the security and the profit is zero (or empty...