confused

Help please... So this seems a bit strange. But then again it may be something some of you may have encountered before. I have a spreadsheet, only 2mb. When i enter figures manually it updates a couple of graphs (no biggie- my laptop can handle this and then some) but it keeps...

I need a formula that has a cell which counts dwelling time in hours between: Cell A2 [=NOW() function] and [mmm dd yyyy H:mm) date format] :confused: Example: How long a package has been on a front door step, in A1 [this is the date and time the package arrived], A2 [Is the =NOW() function]...

I have a cell in a Microsoft Excel Worksheet row with a calculated formula. If this cell is Null, Blank, or Zero I would not like the row this cell is in to be printed. Is there any way to do this? :confused:

Simple IF Statement is not working. A1: 2015.52 B1: =IF(A1-INT(A1)=0.52, "TRUE", "FALSE")........ The result on my sheet is FALSE.....WTF :confused: Any ideas????????

This appears to be very strange I have a line in code which reads NewPassword1TextBox.SetFocus It was working just fine, now it causes an error If in Debug, I delete SetFocus press Ctrl+space and repeat SetFocus, the line continues without error and sets the focus correctly. When I run the...

hi all, How can I improve both formulas to work even if #N/A and #Value ! appear in the column? =SUM(SUMIF(E3:F655,{"W","L"},AO3:AP655)) =SUM(SUMIF(AR3:AS655,{"<0",">0"}))-AN1 :confused: thanks

:confused:

Hi there, I am trying to apply conditional formatting across a worksheet, based on this formula; =BC3<bc14">< BC14</bc14"> HOWEVER I have read multiple forums/blogs/posts about this and I can't seem to get the conditioning to apply across further rows/columns. I am not using absolute...

I need this formula =IF(SUM(AP18,BS18,CU18,DW18)>0,SUM(AP18,BS18,CU18,DW18)," ") to be written like the one below, but using the same line and column references as above. =IF(AND(ISNUMBER(N18*L18),MEDIAN(N18,L18,0)>0),N18+L18,"") Help please :confused:

I have this formula and i know what it does but i am not able to understand how it works. =TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",255)),255)) i am confused as how this formula works and what is the role of "255" in this ? Thank You!

Hi, I'm Selva from Logistics background... i have develop excel format with check-boxes without VB.. if there any possibles to make it with formula... since, i don't have knowledge of VB... Pl help :confused:

Hi All,, This is my first post and i am hoping someone can help. I have a dashboard which represents a speedo from a car, there is one dial on this already and now i need to add another, however i have no clue as to how to do this, can anyone help? Regards :confused:

Good Day, :confused: I need your assistance with this minor problem that is doin my head in. I have a list of numbers (my race ratings). Example: 86 100 84.5 ? 82 ...

Hi All, I have tried (on line) to find answer to my question but instead totally confused. I would like to Get next unused sequence number 10223 10224 10229 10304 I need to get 10225 Yhank you in advance.

Hi All, I'm trying to create a file for others to click a button to enable the file to become a shared file. Is there a code that I can use that could enable me to do this?? Many thanks in advance! R/ Pin :confused:

Hey Guys, I'm losing my mind a bit here trying to get my Save As dialog box to look normal again. I've done a fair bit of googling and can't find a fix (or anyone that's ever had this problem!). The below screenshots show what my Save As box looks like now, vs how it should look. Does anyone...

Hi Guys, I have a question that I am totally stuck on - I have got a sheet where I need to pick a name from list of names randomly - I have the formula to achieve this goal already and it works great =INDIRECT(CONCATENATE("C", RANDBETWEEN(1, 2500))) however I also need the formula to ignore...

I have a button (Form Control not ActiveX Control) that when pressed, calls a sub procedure inside inside a worksheet module for the worksheet that the button is on. For whatever reason after opening the workbook the first time I click on the button, it produces a 400 error: Every time I click...

I am looking to make what I enter in a cell (a date) to a number (a cost). :eeek: For example: 26/07/2016 in one row, I want to make this equal 17.1 in another cell so that I ultimately have a column of dates that will equal numbers, then I want to add them all as a total costing per year...

I have a set of data in a column consisting of a material listed with a corresponding subset of data listed in the next column. These subsets vary in dimension and I would like to merge the values in the first column so that there will be one preceding cell for each matching subset of...