Comments on: Basic Excel formulas & functions with examples

Comments page 3. Total comments: 412

1. 

   KULDEEP says:
   2019-08-03 at 5:30 am

   Same example while using shows error.
   formula used is =(AVERAGEIF(A2:A8,E2,B2:B8)) but error shows as #DIV/0!

2. 

   KULDEEP says:
   2019-08-03 at 5:29 am

   Same example while using shows error.
   formula used is =(AVERAGEIF(A2:A8,E2,B2:B8)) but error shows as #DIV/0!

3. 

   March says:
   2019-08-03 at 1:34 am

   How to salary in excel

4. 

   Haris says:
   2019-08-01 at 6:14 am

   i wanted to ask whats is the logic of *1 or +1 in below mentioned formula for example =DATE(2019,MID(B2775,4,2)*1,LEFT(B2775,2)*1)

5. 

   TianChai says:
   2019-07-30 at 3:19 am

   How to change from S12223 to S122-23?

6. 

   Payal Verma says:
   2019-07-27 at 6:49 am

   Hi
   I want to write 265324 Lac as 2.65 Lac in open office.
   Pl. help with the formula.
   Thanks

7. 

   krishna says:
   2019-07-26 at 4:18 am

   how can i create A New Sheet In a single excel file

8. 

   Michael says:
   2019-07-25 at 3:10 am

   Hi, Im hoping someone may be able to help me with this.
   Currently I have these columns:
   C D E
   2 Started Ended Days
   3 08/07/2016 15/07/2016 7 (=DAYS(D3,C3)
   4 08/07/2016 17 (=TODAY()-C4)
   I have a formula in another square to count the number of completed investigations that were completed in less or equal to 28 days - =COUNTIFS(E3:E4,"<=28")
   However, I only want the formula to count those investigations that have been completed, so essentially only where the cells in column D is not blank, it has a date. This will then allow me to show current investigations and time taken to date, plus a count of completed investigations based on meeting KPI's.
   Any help you can provide would be appreciated. Thank you in advance.

9. 

   pavijos says:
   2019-07-19 at 5:09 am

   Please Advice me, how to add personal details together (ex: name, designation office name, mob no, address )i have these each seperate columns, but in the final columns i want all together, what is the formula for these? i hope you understand what i'm asked here.

10. 

    arjun says:
    2019-07-16 at 4:45 am

    20161130 how to convert date from number to dot format in excel
    i am tired this formula =date(left(A..4),mid(A..5,2),right(A..2)),I GOT 30.11.2016.But this format not supported SAP