if formula

Hello, I can't seem to obtain the necessary information for a column I'm trying to calculate. Please see below: <tbody> Unique Identifier Day of Entry Day of call? Timing of Entry 100 1 Before Call 100 2 Before Call 100 3 Yes Day of Call 100 3 Yes Day of call 100 5 After Call...

Hi I’m using the following formula but would like to change it to include more than one result: =IF(ISERROR(LOOKUP(2,1/(E36:E52<>""),E25:E50)),"",LOOKUP(2,1/(E25:E50<>""),E25:E50)) If for example the existing formula was placed in cell B5 but an additional two results could be...

I have code in visual basic that applies a formula all the way down to where the data ends for column D. When I use a vlookup formula, the code works. Below is the code that works: Sub FillFormula() Sheets("On Order").Range("Z4:Z" & Sheets("On Order").Range("D" &...

Hi Community - It's been a while since i've done this and it seemed to have slipped my mind on how to do it. I need a formula to fill a cell color if it is less or greater than another cell, for example: IF(A1<B1"Fill Color Red") Essentially i want cell A1 to fill color Red if it is less than...

Hi Community, I'm needing some help with a IF and INDEX formula, and here is what I have so far: 1) I have a data validation List ranging from A1:A25 (working sheet) 2) I have a data sheet that includes a list of names with their work schedules a) on the data sheet cell A1 will be a name...

Hi there, I'm trying to write code for backtesting of trading strategy. Given: Active Worksheet with: Range C2:C200 with range of Text values: Buy, Sell or empty cell Range B2:B200 with Closing Price Lets assume B2= 7.30 is a price per share Reference Worksheet ("Control") with...

Dear Experts, I need a if formula that solve my problem with conditional Formatting. Like, School scores grading on below Illustration</SPAN>: i) less then 33% Grade Result F and showing in red ii) 34% to 40% Grade Result E and showing in yellow iii) 40% to 50% Grade Result D and showing in...

Hi, I have 24 different sub-Processes and all has different deadlines, for e.g. Sub-Process A needs to be completed in 24 hours from the received date. Sub-Process B needs to be completed in 10 Business days from the received date. If from the drop down a sub-process is selected and received...

Bonjour all, First time poster! Been using this site to help me make some spreadsheets for work. All have been a great help and have been learning new things and tricks every day. Anywho! Thats enough of me....I have a problem I am trying to get around and wondering if you all could help? I...

I need to extract a word between 2 different strings. The first strings starts in any of the following words- LTD, LP, FD or LTD. And it ends before the word "TWO". I'm thinking of using mid function but it can only be used for one argument. Example: I need to extract the following : ASWU...

I am trying to write a nested IF AND Function to produce a result off of a Tiered Fee Table. A . B . C . D 1 . Condition 1 Condition 2 Result if True . Result if False 2 . 1,000 2,000 1.7% ...

Bonjour all, First time poster! Been using this site to help me make some spreadsheets for work. All have been a great help and have been learning new things and tricks every day. Anywho! Thats enough of me....I have a problem I am trying to get around and wondering if you all could help? I...

Hi guys, i have a formula which checks the value of a cell in the "Unique ID" columns against the "Unique ID" column in a different table. if its the same, I have it say Keep, if it doesnt exist, i have it so it says delete. however, a third value I'm getting is #value !. any idea why im getting...

Hi guys, I am currently trying to make a document for work and I am a little bit out of my depth. I'm hoping someone may be able to point me in the right direction or to tell me if what I am trying to do just isn't possible. I have created a data profile which works fantastically well using...

Hi! I am having troubles with an IF formula with multiple conditions. This one works fine : =ROUND(IF(AND([@[Distribution JJ]]="noos - first fill",[@[Distribution 760]]="noos - first fill",[@[Distribution BST]]="noos - first fill",[@[Distribution ONS]]="NOOS - FIRST FILL"),([@[Total bought...

I have the following code to see if 2 cells are equal to each other. If ws5.Cells(rw.Row, 2) = ws5.Cells(rw.Row, 3) Then ws5.Cells(rw.Row, 5) = 1 Else ws5.Cells(rw.Row, 5) = 0 The issue i'm having is that if one of the cells contains #N/A it is returning 1 instead of 0 which is what i want it...

Hello, I need help with IF formula or vlookup for the following situation Column A 100-160 200-210 300-310 367-367 67-67 If my first three digit falls in the above number , I would ike to assign the following values 100-160 value "U020" 200-210 Value "U220" 300-310 Value " U222" 367-367...

Hello, I need help creating a IF formula based on the following situation: Column A 367150 367850 If the 4th digit in column A is 1 then i say " YES" anything else " NO" Thank you in advance for your help!!

Hey guys, Trying to get this to work but no matter how I try it I either get mismatch or syntax error. Hopefully it's an easy fix thanks in advance! Sub Button3_Click() Dim X As Range Set X = Range("D1:D13") If X = "Passed" Then Rows("D1:D13").EntireRow.Hidden = True...

I am trying to create and IF statement that basically will look at values in different cells in the same row and would give me the difference between each cell, however is there is a 0 in one cell it would look at the next available number in a cell that is not a zero and will give me that...