subtract

Hi, I am evaluation a spreadsheet and need create a formula that will evaluate 4 different scenarios... First based on if a text of 2 cells are Favorable or Unfavorable, then add or subtract based on the cell text. So.. this is what I am trying to achieve in 1 formula If D5="Favorable" and...

I have 2 date columns, "Opened" and "Closed". I would like a formula as part of my query that would say "If Closed is null, subtract today's date from Opened. Otherwise, subtract Closed from Opened." Any help in doing this? I am a complete Power Query noob! :(

Need a hand please. I'm not great with formulas in Excel.. Searched the forum with no luck with the help I need. Below describes what I need to create a check digit. Looking for a formula to do this in Excel. Thanks for looking and help. The calculation is as follows...

Hi guys, I'm relatively new to Excel and need to use it for a uni assignment. Basically, I'm testing out the economy of a cafe simulator game, checking to see if the values of ingredients are appropriate for players to complete a level. The orders that arrive are randomly generated, and I...

Hey guys quick question could not seem to find online. I have variable letters for example BN and would like a formula that would subtract that value by one so it displays BM. Any suggestions would be much appreciative.:):)

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.

I have a table with all my employee's names in column A and vacation time in Column E. I have my normal weekly time sheet writing Lost Time to a back worksheet and ultimately into a pivot table. I would like to automatically calculate for each month what the employee has used and then subtract...

I am creating a inventory system for my company and I cant figure out how to subtract from my main inventory. for example main inventory shows 200 form panels i sent 100 to job site A how to I make it subtract the 100 from the main inventory and add to Job site A?

I have a list of names in col A and a list of numbers in Col B. I have a drop down to choose the names with. In a different cell, I want to subtract a number from the number in col B that relates to the name chosen. So if I choose A1, I would subtract the number from col B1.

Hello guys, Trying to subtract a number from a cell until it reaches 0, then subtract the remaining from a different cell and keep that number for the next time. A1 has a value of 50, that is the spare amount A2 has a value of 30, that is the total amount then in B2 I have a value of 10 b3...

I'm using a formula to subtract dates from today. I would like to use a vba to go through each row (I3:I12) to calculate the days remaining from the dates in column (H3:H12). Greeatly appreciate any assistance. Thank you kindly

I have a report that is giving me times in a general format where instead of giving me 12:18 AM it appears as 18 and so on and I want to subtract one column from another, but my issue is when doing so I am not getting a time rather just a general number. For example cell C2 has 18 (12:18AM) and...

Hello All, I am trying to get an excel formula to get result in row#2 based on the value data in row#1. The first value in row#1 is always equal to same value which is 5, following the next number, which is 16, the result must be 16-5=11, and scanning through the next value is 20 subtract the...

Hi all, You've all been so helpful in the past, so I thought you might be able to help me out once again. I'm trying to work out lead times based on a cut off date, I need to subtract the lead time (Column B) from the cut off (Column C) to calcualte the last order date (Column D), however I...

I am working to take a date and subtract the date I submitted the order to find the amount of days I would like to write a statement that says if the box is blank and I subtract a date in the past I want the result to be blank. Can I do this?

Hi, I'm wanting to calculate a time from when a user clocks in to the current time though unsure the best way to go about it. Currently I have a cell with now() Then subtract the clock in time from current time. Though this makes all the cells volatile right? Is there a better way to do this...

Currently i have a roster done where it has start times and finish times for each day and the formula adds up the hours for the week. What i want to do is have a formula that will add the hours together but then subtract the lunch hours or if under a certain amount of hours each day subtract 30mins.

I am looking for help developing a formula that will subtract two columns if a third column is yes. It must be an IF formula of some sort but I am struggling to figure it out. Here is what I want to do. If column K is yes (they did the thing), then subtract the date in column L from the...

Hello everyone, I am trying to subtract from two cells that ends in MB, but cant find a way to do this. Example: Cell 1 value is 2000 MB, Cell 2 value is 1500 MB. All i want to do is subtract from Cell 1 using Cell 2 value and return a result also using MB. No matter what i have tried, i...

As the title says, I want to subtract n from min value first and then the remainder of n from the max value. I thought I had it cracked until one of the values exceeds n. My formula is =IF(C4=D4,C4-(B/2),IF(C4<D4,MIN(SUM(C4:D4)-B4,0),MAX(SUM(C4:D4)-B4,0))) for bot AA and BB...