if

Hi All, ABCDEFGHIJKLMNOP DateSkuCodeQtyPoOrder#NameShip DateTrackingCourierInv#CostShippingVatTotal Inc. VatStatus =IF(OR($B4="",$D4=""),"",IF(B4="","",(VLOOKUP(@$B$4:$B$500,Formulas!$A$1:$F$26,4,FALSE)))*D4) I am using the above formula in column L and M to pull in a cost price for an...

Hello all, unfortunately I can't get XL2BB program to work, so I'll try to describe my issue. It is likely an easy fix but I just can't seem to wrap my head around it. LineValue LineValueUnique? FIBER DSL 029860000 COAX I/E-KUNDE 028020000X TASTET AF...

Is there a way to combine these 4 IF functions into 1 function? =IF(AND(E3>C3,G3>E3,F3>D3,H3>F3),"UP","NO") =IF(AND(C3>E3,E3>G3,D3>F3,F3>H3),"DOWN","NO") =IF(AND(E3>C3,G3>E3,D3>F3,F3>H3),"LEFT","NO") =IF(AND(C3>E3,E3>G3,F3>D3,H3>F3),"RIGHT","NO") The most I could do is write it like...

Hi, In cell R66 I am trying to return a blank cell if the J66 is also blank. I currently have the following formula: =IF(S66="No",J66,"Reference"&"_"&J66&Q66) In cell R66 I have "Reference" and would like this to be blank. Can anyone assist?

I need help with creating 2 formulas for the sheet pictured (I typed the info that I want momentarily, however, I need a formula to generate it in the future). First, I need a formula that will look at G26 & K26 and place text in U30 based on the value in G26 & K26. I know what I want to do...

Hi all wonderful Legends! I need some help with a form I'm trying to create. The basics are below. If the time is between 06:00 and 14:00 a box on the end needs to read DAY, or if between 14:00 and 22:00 ARVO, and 22:00 to 06:00 NIGHT. Then, if the Completed column shows no, i want another box...

Hello - I have a spreadsheet with about 1500 employees. I need to pick a random employee from the list daily, but ONLY if they have a qualifying "x" in a column on the spreadsheet. Example: If there is an X in column C, I want to select a random name from column B. If column C is blank -...

Hi, I want to apply the same data validation to a range of cells ("F8:F51") on worksheet"B". This validation is based on the value in cell "S3" also on worksheet"B" which is populated from a formula based on the value from a range "Unit" in worksheet"A". So for example if range "Unit" on...

Is it possible to return a value in a cell based on the number of coloured cells are in that row. For example if theres 2 coloured cells on the row of the players name under the column "no. cleaned" it would return the value 2.. etc .

Hey, so i have an issue with some data. I have two tabs in the same excel. On TAB 2 in A column, i need it to find data in column I of TAB 1 but only IF a value appears in column F of TAB 1. I also need this to pull only 1 value per cell and not to pull duplicate values if possible. Does...

Hello, I seem to be having some annoying issues with trying to get what I thought was a basic IF/AND formula to work. I even tried just a basic IF statement, and that too, is giving me a hard time. Basically, I'm checking if a value is both >=1 AND <=4 AND if another cell is a number (date)...

Hi, I'm struggling to figure out why this formula wont work, thought this would be an easy one for me! I have a quarterly budget against business unit projects, several projects per business unit that I want to summarise. Q1 to Q4 budgets for each project listed in columns L to O. The criteria...

Afternoon, I have a rather lengthy formula that stops working about half way through. Values 1 Tablet - 27 Tablets work, 1, 2 and 0 boxes work. But 29 - 55 Tablets don't work and I can't understand why! So if I pop any of the corresponding values in AF, for example 1.9642857142857100, it should...

Hi I am failing to write a IF formula which will inform of impact of a bottleneck / constraint - some help would be greatly appreciated Row 7 - Before bottleneck This represents the amount of items I want to process Row 6 - Bottleneck This represent the amount of items that can be processed...

Hi everyone! New user and novice excel user here trying to figure our a solution to a problem. I included a video instead of typing out the question here because it's kind of complicated with the concatenate functions that I'm using. The end-goal of what I'm trying to accomplish is based on a...

Can anyone assist with unpuzzling what I did wrong with this formula? I am still learning how to create MATCH and INDEX formulas. Because of the vast amount of information in the file I would prefer not sharing the cleaned file because of how long it would take to scrub it clean. If I must, I...

I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.

I am coding qualitative data from call center agent notes, and I'm trying to adapt another researcher's Excel method. I've adapted it a bit for my own purposes, and I just can't seem to get this last piece. I'm using Excel for Mac version 16.81 So, I have all my agent notes in Column A. In...

Hi All, My issue is probably simple, but Im in a brain fog! I have 2 columns, in A, I have a list of lesson numbers, and in B a list of unique subject IDs. Example 1 1.1 1 1.2 1 1.3 2 1.4 2 1.5 3 1.6 3 1.7 1 1.8 1 1.9 2 1.10 What I want to do is return only those...

I have the following formula =LOOKUP(DATEDIF(AE4,NOW(),"Y"),{0,4;1,4;2,4;3,6;15,8}) to determine how much leave someone earns based off the years they have worked and when the person is only earning 6 hours, i need to add 4 hours to the last week of the year. How can I do this? Do I need to...