Get instant expert help with Excel and Google Sheets

ok here is what i'm trying to do.... I'm working on an inventory database. cell D2 has a drop down with my unit size, if it's a 14 or 12oz unit than i want to divide cell G2, which is total number of units by the number of units that come on a pallet so that i can get my true pallet count. this is the best i can do.... =if(D2="14oz","12oz",G2/120,IF(D2={"32oz"},G2/130)) Thanks!

i need this word document in excel with dropp downs as specified on the headings`

I need an excel formula that looks across a Row and evaluates if H:2 = 0 then copy the cell G:2 into another cell J:2.

I want to plot dates for client appointments, that will be dictated by a formula (e.g. every 14 days/21 days etc. from Day 1.) I have used formulas to do so from the inital appointment date, however if a patient's appointment changes mid treatment, how can I set that the formula will automatically change the future dates?

the cell checks 3 different columns each in different tables on different sheets, if the value is=< todays date in the cell, then it checks same row different column for certain value if its the value specified then it checks other cell same row if its blank then it takes text from another cell same row. so = cell 4 if cell 1=today and cell 2=value and cell 3=empty. then it checks entire table each row is separated and it does this for 3 sheets. obviously then when the cell thats blank has data entered it will be removed.

I would like to insert a macro where when there is a "9" in cell D4 of sheet "Support" then columns T,U,V in sheet "Manual Entry" hide otherwise the columns "T,U,V" should remain unhidden

I need have the info entered into a cell automtically put the info into a different cell, but only type it once.

I'm trying to create dependent dropdown category lists. My categories have "spaces" and "illegal" characters. Unfortunately, I can't seem to get an example that would work for me because of the "spaces" and "illegal" characters in the names. Furthermore, my list is in another sheet on my workbook. Per my attached workbook, I've created an example on "Sheet 1" with the categories on "Column A" of "Sheet 2" on column "AS" of "Sheet 1". The categories are colored coated in relation to one another. Any help with this would be appreciated.

I want a formula that will count on the number of male & female student per each cluster.

need to consolidate the filters. currently 2 x filters being utilized.