Get instant live Excel expert help to learn how to use Small function in Excel

1. Use price sheet to answer question, insert a box to type any comment. A meat processing company in the Midwest produces and markets a package of eight small sausage sandwiches. The product is nationaly distributed, and the company is interested in knowing the average retail price c

I am having an issue with "IF". I am trying to write a formula: e.g. IF Cell C16 is blank then, i need text "No comparable value" - if cell D16 is blank then I need text "No comparable value" if C16 is greater than D16 by 20 or more then blank cell (same the other way around) - if C16 is greater than D16 by 19 or less then I need text to display "Small sample, further review needed"

I need to calculate the number of female board members and directors for each company, also the % of females and how they compare to number and % of men in the same firms. Only small firms should count and only board members and relevant associating functions.

Hello My GF copied some text from the web straight into her spreadsheet and it put a button that says translate and a small table I tried to delete it but it wont delete. It seams to be on top of the excel cells. She is using windows 10 with excel office 365

I have been unable to open up a excel document. I bought the recovery app and was able to recover a very small portion of the doc. I than noticed that I was unable to open any of my excel docs and was unable to open excel? Help

Can you create me a function that will combine the name into FIL format and will make the first letter as capital & small letter for the others.

could someone breakdown this formula for me :D =ArrayFormula(IF(D$5>=ROWS(B$5:B5),INDEX(Sheet1!C$6:C$21,SMALL(IF(Sheet1!D$6:D$21=$E$5,ROW(Sheet1!C$6:C$21)-ROW(Sheet1!C$6)+1),ROWS(B$5:B5))),""))

Is there anyway to make it easy to capitalize the the 1st letter of the word like for the name, it will automatically capitalize the 1st letter of the last name & first name and the rest was small characters?

Is it possible to format a name? wherein it will automatically uppercase the 1st letter & small case for the other?

Is there any way to easily format the words where in the first character was capital and the rest was small caps? since it tooks me an hour just to edit the thousand of data