if formula

Hi, my boss wants me to create a formula for the prices of his products. He wanted all prices below 99.99 to be rounded up to xx.97 and the values from 99.99 and greater to be rounded up to xx.00 and I have managed to put together a round formula like this...

Hi, I need help with the if formula. I got a basic formula down but now I need to add multiple functions to it and am getting stuck. This was the formula I was able to get for column CN: =IF([@[Years of Service]]*[@[Severance Weeks per Policy]]>[@[Min Weeks]],[@[Years of...

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

Good day, I've got this VBA code below that I'm trying to do but I keep getting a 1004 Application-defined or object-defined error. It works fine without the IF statement so I'm not sure what the problem is within the IF statement itself. Sheets("Sheet1").Range("E24, H24, K24, N24, Q24, T24...

Hi guys. I'm a bit new in VBA coding, but have worked with Excel a lot. I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables. My formula right now is...

Hi, We have a column of emails for employees. Is there a formula to identify if there is a carrier return in the data? Say the email addresses are in column A. I tried to look for a formula but I had no luck.Sorry we are looking for a return of YES in column B if there is a carrier return else...

Hi all, I currently have this formula: Right now the cell is showing a blank cell. I then have another cell that links to this cell through this formula: This cell also shows blank, because the first cell is blank. I then have a third and final cell with this formula: However, this...

Hi, everyone, Is there any way to substitute a character or series of characters from a cell with other characters, but with some exceptions? For example, substitute (or replace) all instances of "X" in cell B1 by cell A1, except "XP", "Xbox", "Xochitl", "Xmas", and a few others. I had written...

Hi guys, I'm not that good at Excel but I've been tasked with making some improvements on a document. In this case I am looking to create IF formulas (I believe that is the right one?) to show certain selections (competencies in this case, it's for recruiting) based on the position level that...

Hello users on MrExcel. I am still a Newbie at VBA, so this question might seem a bit dumb, but i have tried to find a solution for the past 2 days, on and off. Lets just say, for the ease of it, that i have a Cell with the symbol ">", and it can change to "<" The cell i defined as "s" and...

Hi! I have a pricing file where i have various SKU's which are in the type ABC-XXX, AD-XXX & GE-XXX (could also be more but using these as examples). Each SKU has a price. I have another tab where i have listed what the % discount should be depending on the SKU type but don't know how to get...

Hi all, I've read multiple previous threads and after much experimenting, still can't find what I need. I need an answer in Heading 5 (E3) for if the following conditions are met in column Q, R & S (Heading 17 to 19) *if Q, R, and S all have N/A or Y to return E3 a Y (yes) answer *if Q, R...

Hey, I need to Check more than 50 times by applying Filters Everytime. May be an If Formula might work. If A2 begins with 431 then check B2 if its Value is Not "Saudi" , if Correct then fill A2 Yellow. And if A2 Does not Begins with 431 then check if B2 is = Saudi then Fill A2 with Red. I...

I think this problem is just really simple but for some reason I couldn't just get what to do. I have the following formula. My only issue is the highlighted part. =IFERROR(IF(Column A="Supplier",IF(OtherSheet[Date Column 1]="","Not Received",INDEX(OtherSheet[Date Column...

Hi, I'm having trouble working out the below....hoping someone can help. I am working in Two Sheets. Trying to get a formula that does this: Looks for the value of Sheet1 K2, in Sheet2 column B. If that exists, then it looks to see if the balance in Sheet1 J2 is greater or less than the value...

I am needing to add a few spaces between E3 and J3. Could someone help me modify the formula below. =IF(E3="","",IF(C$3<>"",C$3&"","")&F3&" Rev "&E3)&J3 Thanks for the help

I have three cells. A20: 38.2 B20: 39.3 C20: contains IF formula to tell me if A1=B1, then "Good", if not, then "Check" To clarify, columns A & B contain numbers with decimals, row 20 would be the sum of all those numbers for each respective column. However, due to decimals, the totals won't...

Hi, Hoping Toadstool will see this as he knows the history of what I have been trying to do. But if anyone can help I would be so grateful. I am doing timesheets and have formulas in now that work for adding hours over multiple rows and then multiplying it by 1.5 and 2. What I need now is...

hi, can't figure this out. I want to create a formula that will check all of column A, to see if it contains any values other than "October". So here's an example: Column A October October March October April In the example above, the formula should return ether "Yes"...

Dear Sir, I have a formula based on which one excel cell changes value based on other cell value. The formula I am using...