deduct

Hi. I have the following three formulas: =B36+(99*B45) =(B37+B52) =B38+((99*B45)*52) And I would like to change each of them so that First one: from the result of the current formula, deduct the value of B49/4 Second one: from the result of the current formula, deduct the value of B49...

I have 4 sheets, Sheet1, Sheet2, Temp, Base Price in sheet1 I have 2 columns Product code and Values, In sheet2 also I have 2 columns Product code and Values, In sheet1 A column a same product may be there for more than one time with different values but in sheet2 the product code is there only...

I have 2 sheets, in sheet1 I have 2 columns Product code and Values, In sheet2 also I have 2 columns Product code and Values, In sheet1 A column a same product may be there for more than one time with different values but in sheet2 the product code is there only for once without having any...

Please can you tell me if there is a formula / code that will deduct date and time if date and time are in the same cell. ie 31/07/2019 15:00:00 less 01/08/2019 16:00:00 - using format (dd/mm/yyyyy hh:mm) Thank you Marc

Hi I have a UserForm with option buttons combobox and textboxes at the moment it is used for booking in and I have added another option button to book out and I need it to deduct the value, see link below to see how it works. https://www.dropbox.com/s/m95u5skdxnjgj0x/TESTER1.xlsb?dl=0

Hi, I have a userform with a combobox and textboxes and I need to minus a value from the userforn and deduct it from a database. please follow link for more details. https://www.dropbox.com/s/tknfwt064ungls2/Booking%20Out.docx?dl=0

I am rusty as all get out so forgive me for the question. I have a range of cells a1 - z50. I want to add them all in a range. but I also want to deduct a column within that range C1 to C50.

Hi I am trying to do an IF then statement. I have a list of items that if a cell contains I want it to say Deduct or no deduct, no matter what I try the formula only returns No Deduct. The formula is listed below: =IF(OR(J876="EXTRA BUNDLING CHARG",J876="SPECIAL PACKAGING", J876="COMBO GASKET...

I am trying to find the formula in cell B1 Example 1 eg If cell A1 has value 5 Deduct 1 =4 then divide 100/4 =25 Then deduct 25 from 100 = 75 Then add 4 +(75% of 4) Answer would be 7 Example 2 eg If cell A1 has value 11 Deduct 1 =10 then divide 100/10 =10 Then deduct 10 from 100 = 90 Then...

Hi All New to the forum but hopeful someone can help. This is a wok project I have been tasked with but it has me beat. We process payroll weekly but during overtime season it becomes a bit of a pain as our T&A system doesn't deduct a break when employees have done the required amount of...

I would like help with a formula to solve the following Cell A:1 = 7:30am Cell A:2 = 14:00 I want Cell A:3 to equal cell A:2 - A:1 but if the time spans 12:00 to 12:30 then to deduct the 30 minutes from the total time in cell A:3 Your help appreciated

Hi, I'm require a formula to deduct available from total required. If the value is greater than Option 2, then it will equal the value of Option 2? Thanks for any help. <tbody> Total Required Available Option 2 Total Sum Answer 293 85 164 ?? 164 293 157 218 136 329...

<tbody> I J K L M 1 100 200 0 175 125 2 0 125 0 175 125 </tbody> ROW ONE: When entering a value in L1, I would like the amount to deduct from I1 until it reaches zero before deducting from J1. M1 is the balance for the row ROW TWO: Is how it should look if the formula is correct.

A1 is start time, B1 is finish time, C1 is B1 - A1 to give total time worked that day. Is there an easy way to auto deduct breaks in C1 as follows? less than or equal to 9 hours deduct 30 mins break More than 9 hours deduct 1 hour break All cells to be 24 hour format without : entered as 0900...

Bitcoin calculator - Google Drive Hi guys, I'm new to the forum and need some help. Above is the link to a calculator a friend has made however it's not quite finished. How it works: I start with a number of packs (B10) which is determined by the starting balance (B3) and each day the...

Hello everyone, I am experimenting with an expenses report. It has a basic form, as described below: - Rows: Jan, Feb, ...Dec - Columns: types of Standard Expenses, total "Standard Expenses", other types of expenses, total "Expenses", Income, Savings, Bank Account no.1, Bank Account no. 2...

I have a table showing stock items with a 'last issue' date. I want to be able to calculate how many years from today the last issue was. The list is approx 12000 line long!

any assistance would be really appreciated , thanks !