returns

Hi, The below formula is suppose to check column A for vaues below 1000 and B for values below 500 an if true want "Yes" retunred otherwise ant "No" returned. I want to adust the formula so that B2 only returns values over 1 as well as those under 500, how can this be done...

Is there a formula or way that you would look at all the cells to the left of it, and return the rightmost cell? For example, ABCDE----------FORMULA (Returns E) ABC-------------FORMULA (Returns C) ABCDEFG-------FORMULA (Returns G)

I need to return a date after 30 days and if it is weekend then return Friday. It is okay if the Friday date is less than 30 days because I can be before a deadline but not after. I have this formula but it still returns Sunday...

Hi all, I got this excel sheet named "Data Gel" where i add data into. in column A is gel code (for example 1050). in column B is batch number (for example 308102). In column E and F i note a "x" for when i return the batch. E is production returns and F is other returns. Now i would like...

Hi Guys, Could someone explain how I would merge these two formulas below so that it looks in one range and returns ROUTE, then looks in another and returns COLLECTIONS, I'm slowly getting my head around formulas but bringing them together is what I struggle with...

Hello All, I have a scenario I want to run where I am doing three different improvements to a property, each of which are increasing returns. I want to show the returns assuming none of the improvements are done. I have figured out how to show it given one variable {=TABLE(#UnitsReno...

Hi I want to say from & to dates based on cell values I have this formula: ="From "&D$15-SUM(D$14*7)&" To "&(D$15-49) which returns result From 43602 To 43651 so to convert serial numbers to date format I tried: ="From "&TEXT(D$15-SUM(D$14*7),DD-MMM-YY)&" To "&TEXT(D$15-49,DD-MMM-YY) But...

Hi I have this as data in column A , B to create a pivot test 1 Test 1 Test 1 When I do a pivot it returns on the data above it returns only 1 line as test 3 (3 is the total) '************************************* Is there anyway the pivot returns ? test 1 Test 2

Hi, In A1 I have blank containing formulas. In B1 I have in IF function a logical test checking if A1= blank then TRUE. I tried =IF(isblank(a1).... and IF(a1="")... but somehow it returns false. What to do?

I have 10 columns which either take the value "A" or "B" The correct pattern should always be "A"s followed by "B"s something like: A A A A B B B B B B A A B B B B B B B B A A A A A A A B B B I need a check which returns TRUE if the user mixes up the pattern such as: A A A B A A A B B B How...

I have a PowerPivot table similar to the following (obviously thousands more lines): <tbody> P&L Category Amount Something else I may Pivot on Sales 100 A Sales 100 A Discounts 20 A Discounts 30 A Returns 10 C Sales 200 C </tbody> I want to get a summary of Net Sales in a Pivot...

Afternoon Trying to get a cell to return different messages based on if a Vlookup gets a return or not Ie, Vlookup in Cell G8 returns a result - B8 gives instructions on what to do next (Text in cell A13) Vlookup in Cell G8 returns #N/A result (Failed return) - B8 gives different instructions...

Hi all I am trying to SUM multiple vlookup values as below: =VLOOKUP(A3,Academy!A:M,13,FALSE)+VLOOKUP(A3,'AJ Blunt'!A:M,13,FALSE)+VLOOKUP(A3,BUILT!A:M,13,FALSE)+VLOOKUP(A3,Carbridge!A:M,13,FALSE)+VLOOKUP(A3,'Carter Corp'!A:M,13,FALSE)+VLOOKUP(A3,'Cleanaway - Transpacific'!A:M,13,FALSE) Column...

I want to find the first column in a range that contains a value. I can find the last column that has a value with the following array formula, where the values are in cells T1:Z1: {=MAX(COLUMN(T1:Z1)*(T1:Z1<>""))} I would think that the following would work but it always returns 0...

I have the below formula which picks up the column header of the most recent date that is in a cell between N2 to Q2 and X2 to AA2 (ie not in o2 toW2). This works fine until a date in o2 is the same as N2 (providing there is no further dates in the later cells in the formula. If this happens, it...

Dear all, I'm having a problem regarding the following: I'm trying to look-up values in a sheet and to return a value that corresponds with that value. For example see the image. For example, A1002 can be done with the INDEX MATCH combination. However, this function only returns one value. If...

When I run this code, the watch value displays the correct values, but when I plug the formula into my worksheet, it displays different values. This is what I used in the Immediate window ?TOP(Worksheets("Exp").Range("C24"),Worksheets("Exp").Range("PT_Exp_Total"),1) It returns: Hair Cut...

Hi, Below is part of the formula. The error is in the beginning. When evaluating; first logic test= FALSE, instead of running the formula in the "FALSE" section, it returns #VALUE !. Why? I can not see anything wrong...

Hello I select a range of cells for the IRR formula and it returns #NUM ! I formatted the range to be Numbers but nothing changed. Any idea?

Hi I have a spread sheet which shows employees (trainees etc) who are under 18. In cell B2 I have thier DOB. Then in C2 I want a formula that returns the date of when they would reach 18. Anyone know how to do that?