I am looking to have a single cell where a user could put "+" or "-" and then a number in order to add points to a subtotal. This would allow points (Which are calculated) to be added/deleted to the total for usage elsewhere.
In N8, the user would have the option to place points, and the "+" or "-" preceding the number would tell the formula to add or subtract points from the subtotal.
In doing this, Excel doesn't like to see the plus or minus as text, but rather as an operator. I would like to use LEFT or MID within an IF statement in order to add or subtract from the subtotal.
My question is:
Is there a way to format this under custom in order to accomplish this? Or would I be better off having two columns, one for adding points, and one for deleting points? The simpler I keep this sheet for my users, the better for me...
Sheet attached. I've found when I don't attach a sheet, people here get snarky.
In N8, the user would have the option to place points, and the "+" or "-" preceding the number would tell the formula to add or subtract points from the subtotal.
In doing this, Excel doesn't like to see the plus or minus as text, but rather as an operator. I would like to use LEFT or MID within an IF statement in order to add or subtract from the subtotal.
My question is:
Is there a way to format this under custom in order to accomplish this? Or would I be better off having two columns, one for adding points, and one for deleting points? The simpler I keep this sheet for my users, the better for me...
Sheet attached. I've found when I don't attach a sheet, people here get snarky.