Hi all
I am now in the process of re-structuring my workbook and have run up against a couple of problems.
The first is on a worksheet that has 6 colums of manual data entry. Column E is formatted as 'percentages'. Column F is formatted as an integer number.
In order to reduce some of the manual entries in Column F; I attempted to use Data Validation to input a zero when the adjacent cell in Column E is equal to 9.5% but to allow a manual entry when it does not equal 9.5%.
I have tried some combinations of IF formulas but without success and there does not appear to be a similar thread when I tried searching for a solution.
Hopefully, someone has come across this problem before.
TIA ...spellbound
Bookmarks