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
Post a Comment