I want to put in place an IF statement that if the cell "K1" has the wording "NIC" then my target cell in this case "O3" should return the code 6199, however if the cell "K1" has the word "Pension" then the cell "O3" should return the code "6999"
Thank you in advance
Bookmarks