are if and countif the same?
In other words, the COUNTIF function counts how many times a specific value is found in a cell range. ... The IF function interprets 1 as TRUE and carrys out the value_if_true argument, C3+100. IF(1,99+100, "") C3 is 99 and 99 + 100 equals 199, the IF function returns 199 in cell D3.