Sunday, August 20, 2017

Excel learning: countif, dollar sign to tk , perc in cell

Countif certain text value in a range

CountA counsts the blank in a range

Product - just multiply two cells

Sumproduct

AND

OR

Dollar convert number with Tk number when cell type is given in that format.

Perc converts decimal value with multiplication of 100 and puts a percentage symbol. For this cell datatype should be converted to percentage

With dollar sign if you want to do so in tk in MS Word, you need to convert the timezone to Bangladesh

No comments:

Post a Comment