formula

I am trying to make one formula that can incorporate many ifs, ands, and ors. Here are my individual statements: If D13 or H13 is “Lead” or “Lead-lined” then K13 should be “Lead” If D13 and H13 contain “Non-Lead” then K13 should be “Non-Lead” If D13 and H13 contain “Unknown” then K13 should...

G'day, I need a formula to do the following. If cell contains a value with the number "0" anywhere in the referenced cell, the number "1" is returned, and if it contains a value with the text "EDO" anywhere in the cell a ".5" is returned. If neither of these is found a 0 is returned. Any help...

Hi there, It's been a while since I have posted here. I've had great help in the past so fingers crossed the same can be said for this time. Anyway, I have a fantasy premier league league which I am the league admin of. This season we are doing a head-to-head format which is posing new...

Hi Team, I have an Excel template which itemises a list of items. The numbering of each item is what makes this task particularly challenging. Depending on the column that the item is sitting in determines the numbering increment. A picture is worth 1000 words so I'll show the general gist of...

Hi. I need some help with VBA code that should copy value from one cell to another. I have Defined name named ExtractCurrency with formula: =RIGHT(GET.CELL(53,ינואר!$I8),3) It working perfectly with direct formula in the sheet...

Hi, I am fairly new to Excel, and I am looking to create a random number generator that can exclude random numbers (these random numbers are not always the same.) I need to create this in sets, for example, A 1 through 12, B 1 through 12, and so on. Would it be possible to have the excluded...

I have a table with cell value (Codes) in column "E"and date value in column "I" and because of these codes might be duplicated many times while I need only maximum two cells can be valid with the same code based on the date value in "I" if >=TODAY(). so I need a help please to check if there...

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