Excel gives people the option to choose how their tasks should be accomplished. People compare data differently and in this way, they like to express their work differently apart from other people.in some cases, some people want that in cases where a condition is false or isn't met the cell value should remain unchanged. In that, there is retaining of the old value in the cell if the condition is false. The value in a cell where the IF function is used should change only if the condition being tested by the IF function is true if false the cell remains unchanged of the initial value. Conditions are either true or false so if it's false then the value shouldn't change. There are a couple of steps to be followed to achieve this. These steps include the ones discussed below in detail.
From your computer, open a new excel sheet and record the following data records if you do not have any other excel sheet data records to rely on.
The above data set has two columns for both names and marks. The table is complete without any blanks. We would like the data set to remain the same even after having an IF statement that will return a false statement. To do so, we will have to alter the IF statement values. For example in the formula; =IF ((B2=54), TRUE,""). From the above data set, the formula will return a true value. The formula will change the value in cell B2 because the statement is true. However, if we use a false statement, no change will be done to the cell value and so the original value of the cell will remain unchanged if the condition is false.