Get instant live Excel expert help to learn how to find range in Excel

I need a formula so I can get the quantity of a product after it is sell by 70%, and then I need to check in which range is the left quantity so i can add 350 if the left quantity is in a range of 1 to 100, and and 300 if the left quiantity is between 100 and 200

Hi, I would like to create an excel formula as I wish to allocate a Letter for a specific range of numbers as follows: 0 - 47 = E, 48 - 61 = D 62 - 73 = C 74 - 86 = B 87 - 100 = A Could you please show me what excel formula I need to create if I am referring to data in Cell AE3? Thank you so much

Conditional formatting, how to have entire row colored if blank, but uncolor if one cell in range is filled

Excel format for icons for a range of data I need an green icon for cells within 20% of an average value

Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will receive no additional deductions.

Display Sheet1 and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12, type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:D12. Apply the Heading 3 cell style. In cell A13, type Goal Amount.

Copy the range C6:D6 to cell B13. Click cell C13, and then use Goal Seek to determine the projected amount of Endowment Investments in cell B13 if the value in C13 is 10%.

Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13, from the Cell Styles gallery, apply the Currency [0] cell style.

i need help with IF functions in excel On the Cities worksheet, click cell E13. Depending on the city, you will either take a shuttle to/from the airport or rent a car. Insert an IF function that compares to see if Yes or No is located in the Rental Car? Column for a city. If the city contains No, display the value in cell F2. If the city contains Yes, display the value in the Rental Car Total (F4). Copy the function from cell E13 and use the Paste Formulas option to copy the function to the range E14:E18 without removing the border in cell E18.

I'm trying to insert drop down box in excel. I've created a table, and then gone into data, data validation and selected the cell range for the list but when i click on the drop box the narrative within the cell is the cell range NOT the list content. Please help