if function

Hi All, Hoping this is easy for all you experts out there. Im trying to do an IF statement based on a difference in time, I have entered =TEXT(Late time-Early time),"h") so that the time difference is displyed in hours only, hours and minutes is preferable but I can see no way of doing that...

Is there a way to create an IF formula holding the false value constant until the IF formula is false? Then after the IF formula is false, remove the constant cell reference? This may sound confusing so I will explain further. I am currently showing a retirement plan graph showing...

Hi all, I have the below code and this is what I want to achieve: IF L1=1 AND B1="" AND C1="" then I want to prevent the file from saving. In all the other scenarios, the file should be saved. I need to also be able to specific Sheet name. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As...

I've tried so many options but it only seems to return one answer. E.g. The values I have are [A1] 41, [A2] 0.08, [A3] -2 and [A4] -13. In B1 I have: =IF(A1>5,"High",IF(A1<-5,"Low","Mid")) This returns "High", which is correct. But I drag it down into B2, B3, B4 and the cell ref A1 changes to...

Hi I have a data set with 2 date columns (start and end). For each record I need to determine if TODAY is before the period, during the period or after the period. My formula works OK if I'm testing TODAY in either start date or end date but I don't know how to test them together. My current...

I'm trying to write a nested If statement and it's driving me nuts. Basically, if I14 is blank then check for these multiple conditions, which will require more If statements. If I14 is NOT blank then check for these multiple conditions, which of course involve more If statements. I can't seem...

Good day, I need to combine this function with vlookup. Due to i need to ensure no bar code data are missing if something occur while handling this. =IF(A10="","",IF(A10='BARCODE REGISTER'!A10,"PASS","NG")) So if someone scan without follow the sequence number. The bar code will also detect...

Hi there, I am trying to construct an IF Function for the following problem: Data: 5 collums of data (A,B,C,D,E) and 33 participants. Conditions: define person as 'high risk' if either '3 out of 4 values (A,B,C,D) are smaller than 10' OR if '2 out of 4 values (A,B,C,D) are smaller than...

I have gave this a good bash and got close but struggling as it is text. So here is the problem. Col A and C are working great. Col. A = dropdown options (15ft basket, 10ft basket, 30ft pipe) Col B = 15x8x4, 10x4x2, 30x1x1 (Dependent on col A selection). Col C seems to be working fine with...

I have a "comments" column that will randomly include comments and a date string */* (eg. A1 = "del 5/20", A2 = "expected delivery 6/1", A3 = "4/7", A4= "delivery 11/01", etc.) I want to find that date string in "comments column" and post in the adjacent column as standard date format...

I was curious if there is any possible way to run a function within the if function such as: =IF(IS BLANK(G3),"","") but I would like to insert the function =DATEDIF($G3,$M3,"M") in place for value_if_false so if the IF is false it would calculate that formula and display accordingly

I am having difficulty getting an IF function to work. =IF(I3>0,"I3", I3+P2, "0") I want this to happen: If cell I3 is greater than ZERO, then show what is in the cell, if not, show ZERO AND then in column P3 have the sum of I3 and P2 Can anyone help please?

<tbody> I've tried all the functions and nested functions that I'm familiar with, but can't get it right. Below is what I'm looking for. If condition #1 is true and condition #2 is true, then do formula "A". Or If condition #1 is true and condition #3 is true, then do formula "B". Or if...

Hi I have a condition that either returns a profit or does not return a profit. So if there is a sale, column A = S. If there is no sale, column A = NS If there is a sale then the return (column D) is price (Column B)*quantity (number of units) (Column C) If no sale then the return is 0...

Hi all, I am trying to cap this formula to 15 =IF(B2=1,(C2*12)/1000," ") B column contains number of stems. C contains stem diameter. H contains =IF(B2=1,3.141*(I2^2)," ") which calculates the root protection area and I column contains =IF(B2=1,(C2*12)/1000," ") For example currently: Tree...

Hi All, Hoping someone can help me out with this function: I have a huge sheet with 20,000 rows that contain text and somewhere within that text a number from 1-200. I'm trying to write an If formula that will tell me if the number in the text string is between two values (1-14), but the...

I'm having trouble writing a formula that does the following: If "ERR" is present in any cells within the range, return "ERR" If "ERR" is not present in the range, return the average of the range Seems like this should be a simple formula I just haven't figured out how to make it work as...

Hello - I am looking for a formula that will return "A" if the date in B5 is equal to or less than a year ago, and "B" if the date in B5 is greater than 1 year ago So far I have: =IF(C5>=DATE(YEAR(B4)-1,B4,B4),"A","B") C5 is a date that varies B4 is today's date =TODAY() It returns: #NUM...

Hi all I could really do with some help as I can't get this formula right. I've been trying to use IF INDEX MATCH. IF A2 contains 2016 INDEX data from Column C MATCH H5 postcode with X5 postcode I basically have numbers in column C that I want listed in a new table, but only if cell A2...

Hi All, Hopefully this is a simple fix for something that is driving me crazy. Basically I have 2 x cells. In the first I have a data validation list where I can choose something. The second cell displays some text depending on what was chosen in the first cell with a simple =IF function. When...