Excel Formula


EXCEL FORMULA's


=COUNTIF(D24:D43,3)+COUNTIF(D24:D43,4) 


=SUM(Range)

=SUM(A1:A10,A35:A50,A95:A100)

=Count(A1:A10)    it count how many numbers are there?

=COUNTIF(A1:A14,"*")    it count how many texts are there.

=COUNTA(A1:A10)   it count how many cells you have filled.

=COUNTBLANK(A1:A10)   it count only blank cells.

=COUNTIF(A1:A100,MLS)

=COUNTIF(A1:A100,

= Average(A1:A10)

=max(A1:A10)

=min(A1:A10)

=large(A1:A10,2)   it will count 2nd highest value

=small(A1:A10,2)  it will count 2nd smallest value 

=upper()

=lower()

=proper() capitalize 1st word

=left(A1:A100,4)  it will provide you 1st 4 words

= right(A1:A100,4)  it will provide you 1st 4 words

=mid(A,2,3)

Covert Numbers into word

   =Numtoword(column no. e.g. A21)

set date format in excel

=TODAY()

=DAY()

=NOW()

=MONTH()

=YEAR()



- Fix the column

    G4   H4

      5     1     = 6     (=G4+H4)

            2      =  7   (=$G$4+H4)

- Provide the color to specific text

press ctrl +1 

it open conditional formatting

custom

enter following command

   [>0]#;[Red](-0)

[>0][blue]#;[Red](-0)

#  numeric value

@ other than numeric value

; ya ;; it will use to hide numeric value

;;; it will hide text and value


if we have to add text behind the value

then

press ctrl +1 

it open conditional formatting

custom

select 0 and write pcsor whatever you want

-




.



.


.

.

.

.




.

.

Comments

Popular posts from this blog

Applied Hematology–II (BMLS 601-18)

HISTOTECHNOLOGY – II & Cytology BMLS 605-18

BMLS 501-18 Applied Hematology-I NOTES