Get instant chat help with Excel and Google Sheets

If 2 numbers are the same in Colum B and has the Value "D" in colum E, mark Both with "D" in colum F

Hi :) I am working in google sheets. I have a formula that pulls data from cells from a column in another sheet IF the value in a corresponding column for that same row matches a certain value - and it works great. However I would like to extend the formula so that it returns results not just for one specified value in that corresponding column but for any one of a list of specified values.

How do I make a dashboard essentially where you click tabs that lead to other sheets. That way all the information you see is minimized behind tabs.

i have this formula currently which works but not if I want it for every day - any ideas ?? (NETWORKDAYS.INTL(L1362,M1362,11,BH!A:A)-1)*("17:30"-"8:30")+IF(NETWORKDAYS.INTL(M1362,M1362,11,BH!A:A),MEDIAN(MOD(M1362,1),"8:30","17:30"),"17:30")-MEDIAN(NETWORKDAYS.INTL(L1362,L1362,11,BH!A:A)*MOD(L1362,1),"8:30","17:30")

how can i get value of from sheet2 (H column) thats equal to sheet1 (A column)

Hi There, I'm trying to write an excel formula that is an If:then statement but includes a range...example: If Cell is > Cell1 but < Cell2 refer to Cell3

I am trying to create a formula so if a % is above 50 then enter 5, if it's between 11 and 50, 10 is entered, if the % falls below 10%, 15 is entered. uf it is 0, 20 is entered. This is what i have... =IF(W32>50%,"5",IF(OR(W32<50%,W32>=11%),"10",IF(W32<10%,"15",IF(W32=0,"20",IF(W32="",""))))) The first part works but everthing else enters a 10. If w32 is 9% it enters 10. HELP

I have a large spread sheet I need to filter. I can't filter because there are to many blank rows and random blank cells. Ideally I want a formula to delete every row that doesn't have something in a particular column. If not I need a formula to delete just the blank rows but not all the blank cells. Every time i delete the blank cells it deletes everything and i can't filter to select the blank rows because there are two many empty rows and headings.

I would like to make the data in one cell populate into other fields on different sheets in the same workbook.

I am trying to build a timesheet in excel and am having trouble with the timesheet calculator