What is the difference between function and formula in ms excel?



What is the difference between function and formula in ms excel?..

Answer / Gayanendra Kumar

To find duplicate values in Excel, you can use a combination of the COUNTIF and IF functions. For example: `=IF(COUNTIF($A$2:$A$10, A2)>1, "Duplicate", "Not Duplicate")`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How does if function work?

1 Answers  


What do you mean by spreadsheet?

1 Answers  


What are scenarios in excel?

1 Answers  


How do you check one excel list against another?

1 Answers  


What are the components of ms excel?

1 Answers  


How do I search for text in excel?

1 Answers  


How do you autosum in excel 2010?

1 Answers  


I have a worksheet that shows total hours and minutes worked, along with the hourly pay rate. When I multiply these vales, I do not get the result I am looking for.what is wrong?

1 Answers  


How do I extract text from a cell in excel?

1 Answers  


What is the keyboard shortcut to show all formulas in a worksheet?

1 Answers  


How much are excel sheets?

1 Answers  


How do do a vlookup in excel?

1 Answers  


Categories