IF CONDITION FORMULA AND DATA TO BE SHOWN BLANK

Article 3.7.1C : EXCEL IF CONDITION FORMULA AND DATA TO BE SHOWN BLANK

FORMULA

1) IF (logical_test, [value_if_true], [value_if_false])
       ex : IF(A2>1, true , false)

2) IF(ISBLANK(VALUE), "" , VALUE)
        EX : IF(ISBLANK()A2), "" , A2)