if formula

Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...

So, I have made a what we call "job List" at work. This needs to be updated every month and shows, the next 12 months, with a proposed end date for each project we are doing. It needs to be visual like a bar graph and I wasn't sure on the best way to do this whilst making it time efficient to...

Hello, im having a problem with my formula, i wanted multiple condition, and multiple result, here is what i got for now. Formula : =IF(C6="BADRUN",7000,IF(C6<>"BADRUN",8000,IF(RIGHT(C6,1)="E",12000,IF(RIGHT(C6,1)="C",5000)))) im putting this formula at "KILOAN" - "HARGA" My condition, if...

Hey gang, Can anyone help me with the final formula in my workbook? I need a formula to populate the yellow cells in row 71. The goal of the formula in row 71 is: If the Member's cell in row 71 has a "1", that member's data is pulled into a master summary tab showing national total of all the...

Hello everyone, I am currently working with a sheet that extracts data from a pdf that i upload using queries & connections. the string looks like this in cell B2 B2=IF(LEN(INDIRECT("Page002!C12"))=11,INDIRECT("Page002!C12"), IF(LEN(INDIRECT("Page002!D12"))=11,INDIRECT("Page002!D12")...

Hi Excel Gurus, I am having issues with this formula. Not sure how to make it include return "yes" if the total exceeds -ve 1000. Sample formula used in cell B8 =IF(A8<1000,"",IF(A8<>0,"yes","")) Thanks heaps!

Hi Excel gurus, Can you please help with this? I know there is something wrong with these formulas... In the yellow cell, I have used this formula. (see below) I know I should be writing "No change" somewhere in the formula but is the IF formula the most appropriate one to use? Yellow cell...

Hi all, I am currently trying out this formula: Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!") Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...

I have this formula =IF(ISNA(VLOOKUP(B2,CC_Tracker!B5:B4745,1,FALSE)),"No","Yes") that allows me to search a different sheet and if the reference number appears it puts Yes and if it doesn't then it puts No. This works perfectly for searching on one sheet but i need to check three different...

Hey I could do with some help on an IF formula. The formula I have is =IF(AND(E5="Yes",F5=G5,G5=H5),"Yes","No"). Basically I need the formula to look in column E, to see if an invoice has been received, if Yes then to check columns F,G & H to make sure all costs match. This works great if...

Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...

Hello, I have been trying for a few days to figure this out, however I have run out of solutions and formulas to complete this. I have two sheets and would like to find the value from sheet1 column 1 in sheet2 column 3 and also sheet1 column 2 in sheet2 column 11. If all matches then I want...

I am trying to get a formula like the below that works backwards through a table, i.e. IF N6 contains date="Paid", if false check M6, IF M6 contains date = "Invoiced" and so on. =IF(N6>0,"Paid"), IF(M6>0,"Invoiced") IF(L6>0,"Accepted") IF(I6>0,"Submitted")

Hi all, I have this data sheet: I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry). But I have #DIV/0! errors! :( Is there a way in which I can implement an IFERROR formula for my entire pivot table...

Hi all, I currently have the following setup: I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF. However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...

Good day, Some time ago, I was helped through this forum with creating a formula for my boss' product prices but now he wants it to be modified. The current formula is this...

Hi. I recently lost my job, and am returning to the world of Self Employed, in a service business. As part of setting this business up, I am creating a flat rate pricing system so that I can quickly and easily update my pricing, while giving a visual aid for selling from the customer...

Hello Gurus, Hope you had a nice weekend. I was trying to find a way on how to show the "Count of Indicator" but can't figured it out on Pivot. I was thinking that if it won't work on Pivot maybe IF formula or VBA would be helpful . Raw Account Country Data Score Indicator (value after...

Hello Gurus, I'm getting a syntax error on this part of my code. Anyone who can help me tweak the code below? = = = = Sub Check With Range("Z2") .Formula = "=IF(Z2<0,"Less",IF(Z2>0,"Add",IF(Z2=0,"Zero")))" With .Resize(Range("A" & Rows.Count).End(xlUp).Row - 1)...

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