if

Is it possible that if a specific cell is blank then the desired cell should be blank and if specific cell is not blank then the desired cell should display a picture. I am having such a situation in my result card. I wish if result card shows the "Pass" or "Fail" Status only then the next cell...

List 1 has item numbers, and I want to return total sales dollars. List 2 has the item numbers across multiple locations, and I want to return the total sales dollars into column B on List 1. What formula do I need to put in B2 to return the total sum? (B2 Value should return $315, B3=$230...

Hello, I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following: If the variance to on-hand in column D is zero then return the...

If Column A in spreadsheet 1 matches column A in spreadsheet 2, then column C in worksheet 1 equals result from Column B in spreadsheet 2. What’s this formula need to look like? Cannot figure it out. Column A in both sheets have skus. I need to match these up. Then, I need the item...

Hi Everyone, I made this account specifically to ask this (probably very simple) question. I have gone through quite a few websites trying to get an answer but I can't seem to find one that works. Standard time is Monday through Friday 7am to 6pm Overtime is anything outside of that, so...

Hi, this is probably the most basic formula but I just can't get it to work so I apologize for being slow. =IF(D3<E3,"LOSE","WIN") At present it is showing as LOSE as D3 and E3 are blank. I don't want it to show a result until the scores are input to D3 and E3. How can I do this?

Hi there. I am trying to write a formula to copy across in the highlighted neon yellow cells that checks to see if 10 different members' info matches the filter criteria at the top of the sheet. Should I add a ghost column underneath with same number of rows, and have each cell check each...

Good day. I have a sheet of data, columns D:G Column D is the "parent" of E, E is the parent of F and F is the parent of G. example data below: Column D Column E Column F Column G Bedroom 1 Building Internal Partitions Framework Bedroom 1 Building Internal Partitions...

Hi all, Hoping this one is a testing problem for the maestros on here. I have a G8, which contains the following formula =VLOOKUP($C$2,Variables!G24:H43,2,FALSE)*$G$4 This returns a result of 0.4. What I want to is within the same formula in G8, add something that checks that if the value is...

Hi All I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I have this formula to find content in a sheet called "Test", it works perfectly until later (G94)...

Hi everyone and thank you for reading this. I have tried to play around with IF(ISNUMBER(SEARCH... but I did not obtain exactly what I needed. Please, use the pic below as reference. Column D is the input. Column E is the output. Normally I fill in column E manually depending on what is in...

I want to group different E populations together. I want to know the percentile rank of E1,E2,E3,E4. How do I combine these groups to make a percentile rank of the score? I'm doing a lot of combing populations this way, is there any way to make criteria an OR instead of an AND?

Hello, I've been searching and trying different formulas for some time and to no avail. I want help with a ROUNDDOWN and maybe a MAX formula to calculate tax. So basically, the first $2,000 is taxed at 10%. $2,000.00 is the max that can be taxed at 10%. e.g. if the tax overage is $1,500, then...

A kind soul yesterday helped me with a formula for a vehicle maintenance sheet yesterday. I have an additional request. Can someone please help me out with a formula that gives an "MOT due in..." time, but takes into account the fact that an MOT is only due after 3 years? I have added a date of...

Not even sure where to start. The formula shown is supposed to read the various grades of material in P,Q,R,S column and then find which grade bin it sits in from the reference table and return the BIN type from Row 5. This used to work in an old version of the sheet I have but I'm trying to...

Hi All, Do you know a formula that can return the word "include" if the cell in column A does not start with a number ? Here is an example and result A1 345C5T64 B1 A2 C8744343 B2 include A3 B3 include A4 Non CI B4 include A5...

Hi There! I am trying to write a formula that allows me to place a dash before the last character in a cell text if it is an A,B,C etc. For example, if I have a sku that reads JH004A and I would like a formula that will populate another cell with JH004-A. IF it doesn't contain A,B,C etc. I want...

Hello. Thank you in advance for the assistance. I have a formula that I am trying to update. Currently, the formula references other data points that are on the same worksheet as the formula. The datapoints use vlookups to display the data from other input worksheets. I would like to convert...

Hello, I am trying to build a formula that will will be the following results: I need in column D the result of A + B - C if the amount is less than column C If the sum of A + B - C is higher than C then I need as a result the sum of A + B - C So far I get zero using the following formula...

Hello, I brazenly copied the below macro section to check the range for the value "Not Allowed". And that works, except if none are found it still ends the sub. If none are found, I would like it to process the rest of the macro. Currently, it counts the number of occurrences "Not Allowed"...