if

Dear All, Appreciate your assistance to my inquiry below. I wanted to extract the highlighted decimal number (put in Column B) from the text string cell (Column A) as below. Anyone can assist on the formula? Source - text string cell in Column A 1/11/21 960 C P GL 71,959.26 71,959.26 CR...

I have just tied to use the hyperlink function in an if formula in a cell. Essentially the formula if condition is if there is no value in another cell then hyperlink to that cell (I use the # prefix ) and if there is a value then use that value. In simple terms if is: =If($A$1=“”...

Hello, community I would like to ask for your help, i have a column that has random numbers from 1 to 12 and the format is Time (7:05). In an another column i try to create an if statement =IF(E2<3,RANDBETWEEN(4,8),IF(AND(E2>3,E2<8),RANDBETWEEN(30,40),RANDBETWEEN(8,14))), thus, if it is below...

Hey all, I am needing to shorten this formula so I can put it into a data validation drop down list. =IF($c$11="1", 'LI'!$A$9:$A$99, IF($c$11="2", 'LI'!$b$9:$B$99, IF($c$11="4", 'LI'!$d$9:$d$99, IF($c$11="5", 'LI'!$e$9:$e$99, IF($c$11="6", 'LI'!$f$9:$f$99, IF($c$11="7", 'LI'!$g$9:$g$99...

Hi! I thought I had this - turns out I am rubbish. I basically want to return a value in N3, if F3 (text data input) contains a value in N2 (header), otherwise return 0 I currently have : =COUNTIF($F3,"*"&N$2&"*") which works great to return a numerical value, but i want to later get a string...

Hi from A15 : A27 this is the list with drop downs and dropdown are Priority level , and i have priorities. In K5 . i want to get value from list if list from A15 : A27. If list have any At risk , in K5 it must show At risk dont need to check other cells , if list doesnt contain At...

Hello, I'm trying to embed an If function in VBA code but get stuck with several elements of the piece code (functions / brackets etc). The correct code for cell I2 would be =IF(H2=H1;WORKDAY(I1;1);F2) Could someone help me to build this specific line of the code? Appreciated! Hans Grandia...

Hi Excel geniuses, I'm looking for help simplifying this ugly (but working!) formula. First it performs a test to see if a PO is over or under a certain number. (Thank you @Peter_SSs and @etaf !) Based on that PO Number, I direct the next calculations to one of two VLOOKUP tables — one has old...

Hi all, I am trying to get a yes/no answer if a cell is between a time range. It is set up as a table on Office 365. I have tried IF and IFS statements with both AND and TIMEVALUE in it. I have attached a screen grab of what i'm working with at the moment. Any help is greatly appreciated. Chris

I'm trying to make a formula that checks if a code exists in 2 existent columns, if it exists in BOTH, it returns a text, that part works perfectly, I used If, And, Match for it. But when i tried to get the other half, when it exists in only one of both (X-Or) it returns error, because of the...

Hi, Hoping I can get some assistance on this. So I'm pretty much a novice excel user when it comes to formulas and logics; but I am trying to somewhat automate a commission report we use with a few different formulas for requirements. There are a few conditions that need to be met and different...

I have 3 cells that I am looking at: Contact Name Name Word Count Name Fix John John Doe 3 John Doe Bear Bear Joe 3 Bear Joe What I need is to run Conditional Formatting formula to highlight the CONTACT NAME column if the number in the NAME WORD COUNT column is equal to 3 and if the...

Hello all, i want to extract data from column A to column B using formula. If number of characters after the hyphen is less than or equal to 4 then it has to be copied to respective B column cell. Refer example. Thank you. AB1HeadingExtracted...

Greetings, I have my Blood Sugar Log that I need to add an IF Statement to a cell that has 2 IF Statements. =IF(K23="","",IFERROR(RIGHT(SUBSTITUTE(TRIM(LEFT(SUBSTITUTE($V$11,"Morning",REPT(" ",255),1),255))," ",REPT(" ",255)),99)+0,"")) I need to check back a day at lunchtime to see if I was...

So I have a list if things in a sheet. In the A column there are names, B column has a date, C column has a number and the D column has another date which is 5 days from the date in column B. I want to be able to come up with something that when someone's name is written into column A and if the...

Hi guys, I need some explaining in IF formula. How can I write condition with IF to automate check my Data Base from my table automatically? something like this: =IF( E3=F3 then past value from G3 in C3 cell) + =If( I already have value in C3 cell but it is not the same as in G3 then change it...

Good Day, Good People I'm having some troubles writing the proper formula for my data Basically, I'll fetch the data from one sheet (RAW) to another main work area (IIIE), but there's some error Here's my goal: First, check if the corresponding value on RAW is greater than 0 (if not, print the...

Hi, I have a problem where I have price data from one company and want to allign it to our products. Basically saying, if product A falls under these measurements it is in group 1. If Product A is in group 1 and has a weight of 1 KG the price is 1,00 but if the product is 2 KG the price is...

Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...

Hey everyone! i need some help with my vba, heres my code: "Public Sub importTextFile() Dim textfile As Workbook 'Set textfile = Workbooks.Open("") Dim openFiles As Variant Dim i As Integer openFiles = getFiles() If openFiles = False Then...