=if

Hi all. I have a function below which compares two values to two reference cells and works as expected: =IF( OR( AND( AL33 >= $AW$15, AM33 < $ AW$15), AND( AL33 >= $AW$17, AM33 < $AW$17) ),"Y","") However, when I add =ROUNDUP in the formula it isn't recognized as a formula, and instead becomes...

Good day all, I was making a spreadsheet and ran into an issue that I was not sure how to solve. I am using the =CONCATENATE function to write a text string for an email title as well as using =IF statements in it to determine some variable. I ran into the problem when I wanted to reference a...

I am trying to create a formula in excel 2007 without using =IF and I am struggling to come up with a solution. Cell A1 is the input cell and cell b1 is another input cell. I am creating a table from A5 to a50 starting with A5=1 The formula I am looking for in row B1:B50 is equal to cell A...

Ok for some reason when I run my Macros things get moved around in my Manual labels I created. So to get around this I shut down all my formulas in my manual label sheets then rename em back in. Easy solution. But lately I have been running into issues??? I am not sure if it is because of the...

I am copying the following formula down a column and need the f2 to remain constant instead of canging to f3,f4 .... =IF (OR (C10=0),"",INT (YEARFRAC (C10,F2))) Can anyone help?

Good Evening I'm trying to use an IF formula with an embedded VLOOKUP formula. I need the formula to search the grid for a specific term, and if it matches, use the VLOOKUP. However, if it doesn't match any of the terms, I want it to match the original term it was looking for. The formula...

Hi i would like some help with a formula basically if a cell let's say A9 has a value i want the cell to take the value in another cell away (D9) the cell in question is J9 and includes the current formula =MAX((D9-E9+F9-G9+H9-I176),0) Any help welcome Thanks

Hi, I am trying to return values of Invoice or Credit Note in column B based on the first letter or digit from column A. The table below shows what the requirements are (E.G M or 4 = Invoice, 7 = Credit Note. However, I'm stuck with the formula below and unsure of the formula required to allow...

Hi all, within a macro I am trying to apply an IF statement to a cell. Basically IF the current date = Monday then return the date from 3 days prior, else display date 1 day prior. eg: current date = 4th July 2016(ie a Monday) = result 1st July 2016 (ie previous Friday date) current date =...

=IF(J22="","",IF(G9="","",IF(D10="","",IF(AND(J22<>G9,G9=D10),"Closing Disclosure Interest Rate does not match Note or ELC Interest Rate",IF(AND(D10<>J22,J22=G9),"ELC interest Rate does not match Closing Disclosure or Note Interest Rate",IF(AND(D10=J22,G9<>D10),"Note Interest Rate does not match...

I spent a good bit searching for this answer before I posted, I didn't want to ask something already answered, but I couldn't find the answer anywhere (probably not using the right search terms). I fill out spreadsheets a lot with duplicate information, such as phone numbers. I want an IF...

Afternoon all, This will be a simple one for somebody out there but here goes. I have 3 tabs (Summary, sheet 2, sheet 3) All three tabs have the same columns in the same order. However, there is only data in the summary tab at the moment. Name, Address, Town, Telephone number These are...

Thank you for clicking on my thread. I'm fairly proficient at Excel formulas; however, this one is just becoming too much. I feel a fog settling over my brain. :) I have three fields: D10, G10, and J10. All three will have dollar amounts manually entered, and I need a formula turning out...

Hello, I’m attempting write a funky IF command to construct the matrix below and I’m stuck. This is what I'm trying to achieve. I know it's a combination of IF and perhaps the RIGHT functions, but I can't seem to put it all together correctly... <tbody> Species 1 (1) Species 2 (10)...

Morning All, Can anyone help convert this into VBA for me? I need it to automatically run as the worksheet is filled out: =IF(COUNTA(M1:V1)=10,TODAY()+60,"") Currently used in column W Thanks in advance.

Hello all! Trying to pull something off here, but I'm not sure if it's possible. Below, 11/8/2015 is A9, 21 is C9, and 23 at the bottom there is C18. <tbody> 11/8/2015 Wordy 21 33 11 4.5 4.5 4.5 Max 10 300Editors 7 11/9/2015 Wordy 9 23 </tbody> From 21 down to...

Hoping someone can help me here! As stated on the title, I'm trying to create a formula that will use either one of two VLookup formula's based on a variable that is in play. =if(B3="Company1", (=vlookup(G3,'Table worksheet'!A:F,6,FALSE)), (=vlookup(G3,'Table worksheet'!A:F,5,FALSE)))...

I have been working to create a formula to work out sales commission from sales targets. So far I have this formula: =IF(B13<B11*0.70, B13="0"),IF(B13=(B11>=0.7,B11<0.99, B13*0.075))) Any idea why it isn't working? Thanks,

I am trying to pull data from multiple columns from a survey via google forms some of which are blank and some of which have a text. There is only one cell with text for each row in columns H-N. In rows H-N there is one cell with text per row. I'd like to be able to pull each of the text's...

I need a formula. Cell A19 contains 'JR', note that it will not always contain JR so I need the formula to use the contents of the cell no matter what it changes to. I am inserting a formula into cell E19 that is to search cells B3, B4, D6, D7, D8, D9, D10, D11, D12 & D13 for the text that is in...