if formula

<tbody> Cost center Dept Account Desc Budget Actual $ Var % var 712 Acctg Revenue 10 1 -9 90% 712 Acctg Salaries 5 8 -3 60% 712 Acctg Total 5 -7 -12 240% 814 HR Revenue 10 10 0 0 814 HR Salaries 11 11 0 0 814 HR Total -1 -1 0 0 </tbody> Let's say I have the above table...

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