I need that users can enter a number in a specific cell and then select a dropdown option to indicate if the number they entered is a POSITIVE# or a NEGATIVE#, to minimize error. Like:
if a user enter an X number, i want that they indicate in a drop drown if it is positive or a negative number. Then; when they enter the X number, based on the dropdown option they select, this same X number have an interaction with the option they select. Basically if the user select PLUS the entered number WILL DO NOTHING, BUT if they select the MINUS option the X number entered will be NEGATIVE in the same cell they entered.
I dont know if this is possible, please help btw i use2011 version Excel