Anybody out there can help with an Excel spreadsheet? What I would like to do is create a formula which depending on a text entry adds or subtracts from the number in the cell above. For example in cell F7 the text is either "IN" or "OUT", if the text is "OUT" I want to add 1 to the number in cell G6, if the text is "IN" I want to subtract 1 from the number in cell G6, this formula would be for cell G7.
Does that make sense and can anybody help? I've been playing around with formula for an hour or so and I can't get anything to work.