extended

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...

The original formula looks like this: <code> =SUM(COUNTIFS(Details!$BA:$BA,"A",Details!$AZ:$AZ,">"&"2018-12-31",Details!$AZ:$AZ,"<"&"2019-4-1")+(COUNTIFS(Details!$BA:$BA,"N",Details!$AZ:$AZ,">"&"2018-12-31",Details!$AZ:$AZ,"<"&"2019-4-1"))) </code> The purpose of this is to feed into charts...

I have assigned a macro to a button on my menu, but I can't find a solution to write and show extended tips. When the mouse arrow is placed over the buttong, only the same name as the buttong is coming up as tip. Have anyone any experience with this...

I am trying to create a pivot table that pulls number of hours and hourly rate from two different data sources, and then calculates an extended amount. To illustrate, below is a sample data source: <tbody>#DAE7F5[/URL] "] A B C D 1 Name Type Hrs Rate. 2 Jane A 10 25 3 Jane B 20 25 4...

Hello. Very new to VBA (very new). I have a spreadsheet with three columns and need to do some work in the last two columns. [Sheet 1].[Column A] - ID [Sheet 1].[Column B] - BUILDING [Sheet 1].[Column C] - DESC <tbody> ID BUILDING DESC A L1 L2 Very Large Extended B L1 L3 L4...

How can I export a report from a table showing the related sub table in the report like I see in access on the extended plus-sign?

Hello all, I sort of know how to use LEFT and LEN but not in this case. In this particular column (A), data always appears in this format with a number on the left and the number in brackets on the right. The numbers can be either 1 or 2 digit. So I just need to remove any digits to the left of...