Hi,
I have "Total amount" in cell "A2", and used amount in cell "B2". Cell "B2" is formatted as number "0,00". So even if I enter 10% in "B2", the value is automatically changed to 0,1. I'd like that Excel VBA would somehow check, if the amount was entered as a percent in "B2". Then, if the check returns TRUE, Excel would multiply percent value by the "Total amount" in cell "A2", and return used amount in cell "B2". For instance, if "A2" has value of 80, then:
1) If I enter 10 in "B2", Excel would leave 10;
2) If I enter 10% in "B2", Excel would return value 8 (which is calculated as 80 * 10%) in cell "B2".
Is it possible to somehow capture, if the amount was entered in percents?
Bookmarks