Understanding IF function available in Excel

[@user-ks2wu3jf7n]

clearly explained

[@uzmivjk]

Thanks sir

[@FatimaGhulamRasOol-g7f]

❤❤

[@tjdewolff5104]

And now I have that unique and very special situation where i have a column that occasionally shows a value (a calander date) in which case I would add 1 to a counter and show that counter at the bottom line...