How to Stop IF Statement running continuously?

Hi guys, I have an IF statement which checks what the value in a cell is then posts a score to another cell according to the value. It works fine, however whenever I click anywhere or do other tasks on the same sheet; the true value for the IF statement keeps firing - basically it adds +2 to the cell whenever I click somewhere.

Here's the code;

Please Login or Register  to view this content.

Thanks guys.

Assignment 2 data.xlsm

Here's the spreadsheet, it is for a uni assignment, I must make a questionnaire basically, the answers of which must return specific values to be calculated towards a life expectancy.

I can't use userforms or controls..I have been instructed to only use msgbox and inputbox.

Bump, please help.

Hi,

Try this.

Thanks, but now I have the opposite problem where it doesnt refresh at all..I think I'm going to make a msgbox saying 'Your BMI is ...' then have that value enter the box and link the assigned values to it.