d10

Hi, Not sure how to do this but I want to have a cell display various message text depending the value input into another cell e.g. if value in cell D10 = 1 then in cell D8 I want to see the message Change if value in cell D10 = 2 then in cell D8 I want to see the message Pump Out I...

I have a spreadsheet I am working on. I was able to hide used items in the drop down list in column D, but I can't figure out how to carry it over to column H. What would be optimal is: 1) to have the same exact formula/drop down list that is in D:D to be in H21:H23, 2) then to have any...

Trying to write a formula for a 3 condition conditional format. In cell D10: If cell D10 = F10 then fill cell D10 a color. If D10 <> F10 then no color. If D10 is blank and F10 is blank then no color. I will use this down the D column but I am only using 1 row for this example. Appreciate...

If I have a table with average ratings of a number of products by people who were given the choice of rating them on a -5 to 5 scale. (1-5 thumbs up, 0 thumbs, 1-5 thumbs down.) These products got generally negative ratings, which makes the relative ratings a little difficult to visualize. To...

I would like to figure out a way to parse through an excel sheet and replace cell values with a formula. I'm guessing this is done with a macro but I've never created macros on my own and so I am not sure how to start. In the example I want to check if cell A10 is a number in which case, D10 to...

I have range D2:D40 with data that gets updated chronologically from left to right. (D2 on Monday, D3 Tuesday, D4 Friday, etc). If we haven't reached the time of the update, then the cell is going to be blank. I also have H2:H40 that all has data. I want to create a macro that checks row D...

Good Evening, I have an ETA calculator (Time/Distance= Speed) that is giving me an error. Now the error takes me to various other bits of codes like my timestamp macro but it's all based on one part here. The Distance (DTG) below is the cause. If I input data into the "S29" cell, it works...

Can anyone tell me what the problem is with this code snippet? Range("D5").Formula = "=match(D6,ChTables!$A:$A,)" Range("D7").Formula = "=OFFSET(ChTables!A1,D5,53)" Range("D8").Formula = "=OFFSET(ChTables!A1,D5,47)" Range("D9").Formula = "=OFFSET(ChTables!A1,D5,51)" Range("D10").Formula =...

I'm getting an error that says you've entered too many arguments for this function. Please help!!?? Here's what I used: =SUM(IF(ISBLANK(D6,D8,D10,D16,D18,D20,D22)))

I have a problem I'm just about to give up on. I've inherited a report from someone who's left the company and there's a bunch of circular reference errors in it (no one bothered checking). I can not for the life of me figure out what's causing it though. The cell above works with the exact same...

I have two cells, let’s say, A1 and B1. They may hold blanks or zeros, I need a way to identify when both are blanks or both are zeros. So, I did this: D10=(1-(A1=””)*(B1=””))*(A1=0)*(B1=0) I test it this way: (A1=”” and B1=””) results in D10 =0, and (A1=0 and B1=0) results in D10 =1, both...

I'm sorry if this has been answered before. I've googled this question up and down and can't find an answer. Is there a way to move your range selection to other parts of the worksheet? When you select just one cell, you can use the arrow keys to move that selection left, right, up, and...

say i have a sales invoice, which has inv no. in range d10, date in j10 and sales item list in the following range b19:n48. can i copy this live data from an active workbook to another workbook (which may be active or not). also the sales item list has 30 rows, but data can be in only 1 row or...

Hi All, I have a value in cell D5 the lowest it will be is 3 and the highest is 20. In cell D10 I would like to return a value based on the value of cell D5 In D10: If D5 is between 3-4 I would like D10 to return D5 + 0.05 If D5 is between 4-5 I would like D10 to return D5 + 0.10 If D5 is...

I have a sheet A , I have to loop through the remaining sheets and look for cell B2 in Sheet A in the range E5 to F76 of sheet B , then in sheet C , then in Sheet D etc and place the vlookup values in cells D6 , D7 , D8 , D9, D10 See link of file below I am having difficulties in establishing...