warranty

Hello Everyone! I'm hoping that I can get some help with a formula on a spreadsheet I've been asked to work on. We manufacture and sell industrial equipment imported from other country which has either 12 months warranty from shipping date for our customers to sell. So once its sold - warranty...

Hello, I recently took over a position at my work and I am working with a file that was not originally mine. I have warranty registration cards that we receive from our dealers once the item is sold to the end user. When the end user reports a failure they are supposed to submit a credit form...

I am trying to set some conditional formatting on cell that are outside the 365 days warranty end date that is entered into the cell. <colgroup><col></colgroup><tbody> <colgroup><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> 19/07/2019 Within warranty 30/11/2018 Highlighted...

Hi, I am pricing 2 extended warranty agreements. The warranties have a upfront price but the customer wants to pay for each warranty as monthly payment over 3 years/36 months. Extended Warranty A; qty 700; $2,000.00 Extended Warranty B; qty 30; $2,100.00 Because the warranties have...

Hi all, I'm hoping that I can get some help with a formula on a spreadsheet. I'm creating an excel that tracks return products base on the serial number. Here is the layout of the spreadsheet. Sheet 1: Serial Number A = Customer Name B = Brand C = Products Code D = Serial Number E = Date Sold...

I have the following tick boxes: "New" in Cell B18, "Used" in C18 and "Refurbished" in D18. I have a "Make" which would just be text entered i.e. "Mitsubishi", "Toyota" etc in B22. If the "New" checkbox is ticked in B18 and a Make is entered into B22, I want it to do a VLOOKUP to my...

Hi, I have a table that I access through ODBC. I can not edit or modify this table in any way. This table has multiple order types. Some order types have a reference id back to another order type. I would like to get the actual order number for those reference id's. I hope this makes sense. Here...

Hi all, Based on a warranty date, I would like to Set a Date and Time Date should be at least 2 days before the warranty expiration date. If warranty date is a Monday, date should be at least Wednesday from previous week @ 10 am or 2 pm Days must only be Monday, Tuesday, Wednesday Time...