minus

Hi everyone, How can this be solved in VBA given S is a result and some number a b c d e f g So how can i find the combination of math expression ( plus/ minus ) so that a + b + c - d -e -f + g = S or a - b +c - d - e +f - g = S Thanks,

So I have a data set that I import off of a website. The positive numbers look good. But this minus sign is double the size of a regular negative. Website value: –0.13% Regular value: -0.13% I've tried to do find and replace, but that doesn't work. The problem is, I use the copy / paste...

Hi =now()-1 is going to subtract todays date by 1 but same time. How can I subtract the time as well, lets say 2hr minus? is that possible? Thank you.

Hello, I am trying to count the number of the additional hours for my Employee in my Shift calendar: For example in February: an Employee has 5 additional hours in the month. But he has minus hours in January Note: that the calculation method is the day, and 1 day = 8 hours I have used the Mod()...

I have dates that are formatted a: 1012019 1022019 4012018 What I need to do is to take those dates and minus 1 from them: 1012019 = 12312018 1022019 = 1012019 4012018 = 3312018 I have a formula that I figured out below (It works but do not know if it the best solution)...

Hi, i wanted to calculate overtime working hours and would like to include below: 1) round total hours to every 0.25 2) weekday >>>> minus 0.5 hr for =>3hrs and minus 1.0 hra for =>6hrs 3) weekend >>>> minus 0.5 hr for =>6hrs and minus 1.0 hra for =>8hrs issue example : if i use END TIME...

Hello all. I am trying to calculate the number of working days (and not counting Bank Holidays) between two cells (minus 1 day) and if the second is empty use today's date. I can find the actual days with "=IF($X3="",TODAY(),$X3-$W3-1)", but this obviously counts all days and not just working...

Link to the file: (Please see tab called "Master") https://drive.google.com/open?id=186WZJRjc4q7kt4NyivnEsmzQOZ9atg9q Problem statement: (Option A - Preferred) Step 1.) If a date exists in the following columns (O, R, U, X, AA), display the latest date in column AJ. Step 2.) In column AS...

Hello Experts, All the information I can find about Solver leads to it being used to identify, from a list of numbers, those which sum to a predetermined amount. Does anyone know if that pre determined amount, instead of being a set number, can be in the form of say plus or minus 20 of a number...

Hello! I have some problem with this function that I don't know how to solve...

A1 has a formula, B1 is empty. I would like C1 to stay empty if either one of A or B is empty, otherwise, A1 minus B1. Any help would be greatly appreciated.

<tbody> column B colum j columnP columnR total of unit unit + unit minus 1unit =remaining unit unit unit =total of unit i insert new row everyday...

Hello, Hopefully I'm explaining this well. So I've got 2 columns, or 2 cells as the example. One would have -1.5 and the other 1.5, I need to use a formula that will identify which one is the minus figure (could be in either column/cell) and then compare that minus figure to another cell. So...

Hi everyone, I'm looking for 2 formulas one that will calculate the minus in column C and the plus in column D. In column A3 and going down, I've got numbers, starting in A3: 1 in A4:10 then 27, 5 36 39 15 8 and so on, what I need in cell D4 is the difference between those 2 numbers in A3 and...

What I want in the cell basically is that if B17-b16 is a minus figure, then use B12 + b13 I thought something along the lines of =IF((B17-B16),"<0","(b12+b13)") but I just get <0 as a response Any help please? Thanks Antony

Hi there, I have a spreadsheet for user info entries. This has been working successfully but something has just come to my attention... If a user enters something into a cell and starts off with a - (minus sign) or = (equals), Excel is expecting some sort of formula to happen and causes an...

I came across the below code to fix a trailing minus sign in some data. The workbook is intended to be a template with a series of calculations from the data on 5 other worksheets. Running the code in a separate workbook completes smoothly and within a second or two. However running it in the...

Good evening, I have a long list that looks like this: <tbody> VPN—Virtual Private Network VPU—Visual Processing Unit WAN—Wide Area Network WAP—Wireless Access Point WAP—Wireless Application Protocol WINS—Windows Internet Name Service WLAN—Wireless Local Area Network I want...

Hi guys, I am having a brain freeze. If I have a number of 700 (A1) but I only want to calculate the difference if its plus or minus 5% of it what formula should I use? I wanted to attach a file but I cannot see the option and do not know how to do it. Thanks TJ

Hi all, I extracted a large amount of data figures. I noticed that the minus sign is facing the wrong way, and thus Excel is picking it up as a text instead of a number figure. For example, 48-. The correct way I want it to read is -48. What's the best way to reverse the minus sign? I'm...