# if formula

1. ### Help me expand my formula please :(

Hi all, I have this formula: Formula: =IF(J4=""; IF(I4>P4; "G4 grant bigger than Total grant (IA) by " & TEXT(ROUND(I4-P4; 2); "0.00") & " DKK"; ""); IF(J4>P4; "G5 grant bigger than Total grant (IA) by " & TEXT(ROUND(J4-P4; 2); "0.00") & " DKK"; "")) I want to expand it, so that it looks my...
2. ### Google Sheet - Count Drop Downs, Total Columns, Check, Array - Errors

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...
3. ### I need help with a spreadsheet I have made for "ongoing project Timeline"

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...
4. ### Microsoft Excel Multiple IFs condition, and result

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...
5. ### IF() formula that checks if member data meets filtering criteria

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...
6. ### Conditionally Extending the Reference of a String

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")...
7. ### IF formula assistance

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!
8. ### IF formula and % calculation returns #DIV/0! error

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...
9. ### How to use OR formula in Excel correctly? With IF and LEFT

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...
10. ### IF Formula

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...
11. ### Help With IF formula

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...
12. ### Get formula that pulls a number from a sentence in a cell

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...
13. ### VBA 4 conditions have to match if matched then write the word "TBC" into desired cell.

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...
14. ### Clear formula to track invoice status

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")
15. ### Implement IFERROR formula for data in Pivot Table?

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...
16. ### Save file as PDF in VBA (macro)?

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...
17. ### Modify array and include 3 conditions in formula

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...
18. ### Problems With an "If" Formula

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...
19. ### VBA / SumIF formula / Pivot Filters

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...
20. ### VBA: IF value greater than and less than

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back