formula

How do I pull in rebate in column G ( after four quarters)? The Sale quarter is an input that can be changed, rebate recognition should change to after four quarters of sale and should do it automatically based on sale quarter.

I work on a sheet where i neecd to check if the value is duplicated in the same column "E" and if date for both duplicated value in clolumn "H" is =>TODAY() then return value as "Valid Stream" otherweise keep it clear i have reatched this formula but unfortunately it has one issue I don't...

Hello, Newbie to Excel formulas. I only know the basics such as =sum and =count. Wanted to know if there was a formula to auto calculate accruals for our PTO spreadsheet instead of constantly typing out the accrual for every employee. Staffing agency so have over 500 employees. Our basic PTO...

Hi good people. I need help calculating the Work In Progress (WIP) inventory for my work. My Excel spreadsheet has three columns. Column A is the item’s unique identification code Column B is the time that the item entered the warehouse Column C is the time that the item left the warehouse Is...

Hi All, I have a debt of about 500.000 USD with an annual interest rate of 4.5% (quarterly added, so every 3rd month, the debt is increased by approximately 4.5% * 0.25 = 1.13%). Me and my friend are able to pay off debt at our own pace. I would like to setup an excel sheet, where I can...

Today we are utilizing a formula in SharePoint that we go update by adding to it and wanted to see if VBA in an excel sheet could help out. The formula is as follows:=OR(ISNUMBER(FIND("PartA",[Item Number])),ISNUMBER(FIND("PartB",[Item Number])),ISNUMBER(FIND("PartC",[Item Number]))). If...

I used to use if then else in Crystal Reporting but haven't figured it out in Excel. I have a column with rows of cells with different percentages in them, let's just say Column Q rows Q2 through Q30. In Column T, T2 through T30 I would like to put a number based on whats in Q. Tte numbers in Q...

I need to determine the range of values from Column A in my dataset where the corresponding values values in Column B are not equal to 0. Finding the the first value (in this example, 7) is easy enough, but the last value is giving me some issues. Anyone have any advice on how to solve this...

Good Morning, I have a set of data with start/end dates which I am trying to split into hour categories so I can dissect further (i.e if a line starts at 5am and ends at 7am I would expect to see 1 hour in the 5 and 6 am columns) My formula splits things up nicely but when the end date falls in...

Hi, I'm trying to edit a spreadsheet where we have a column for 'date sent' (A)!!, and a column for 'date received back'(B). I am trying to make it so that if a date is elapsed by 5 days, the cell turns orange. If the date passes by 10 days I would like it to turn red. If possible, I would also...

I took over the league this year and was given a CD for a golf program that worked with Windows Caveman so I decided to create my own since it is such a small league of old guys! To establish a handicap for this season I manually enterd 5 scores in Columns I through N, in every row, to get a...

Hi All, Really need your help as I am pulling my hair out on how to do this! Basically I have a column (F) which is has a date in for 'Date Response Required By' , and column (I) has 'Impact against programme'. Column 'I' has the formula input into the cells to work out the programme...

Hello , im kind of stuck , I want to find the dates or the numbers of visits of a person In sheet 1 "B2" I can put the name of the person registered , and then in "F3" and downwards it shows me the dates the person was visited , or the number of visits (lets say visit 1 , 2, or 3) In sheet 2 ...

Before I start, here's a copy of the sheets I'm using: Here's a copy of the sheet I'm using: https://docs.google.com/spreadsheets/d/1Y079euBk63RYcgFOPjBFwMlPi53SUAIgZ-h69_o9Hsc/edit?usp=sharing I have two sheets, Expenses and Tax Deductibles. The Expenses sheet has it's data filled via a Google...

Hey Team, I know this topic has been covered a lot but I have yet to find a signal formula to handle all of the possible situations. I am trying to convert fraction feet and inches to decimal feet (Or inches whatever is easier). The possible situations include Inches with fractions B3, whole...

Hi, I'll try to explain this as best I can... I can't share the sheet as it contains sensitive information. I have a table with over a thousand rows full of text, and I am interested in analyzing it based on the final 3 columns. All cells in those columns contain one word. There are only 4...

BCDEFGHIJ2DateJob ReferenceInitial Quote TotalW/LFinal Invoice Total# of Leads per dateSales Per...

Hi, I would like to make every column under "Sat" and "Sun" to appear as grey (for sake of argument call it Hex #D9D9D9). How would I go about this? Thanks.

Hello. I have data in a large array that I'd like to be extracted into a single column, with each unique value having its own cell. All of the data are 8-digit integers that appear throughout multiple columns and rows. Some of the cells contain multiple 8-digit integers, which are delineated by...

I have a column of Currency values, but I want the values to always round up to the next whole number. I don't want to have to enter a formula for each cell, since it is meant to be a quick entry. Example of what is entered into a cell What I would like to see visible 10.10 $11 10.21 $11...