formula =if()

Hey, I'm trying to use the following if statement to create a category column. =IF(VLOOKUP(E4,Med,1,FALSE)<>"#N/A","Medical",IF(VLOOKUP(E4,Surgery,1,FALSE)<>"#N/A","Surgery"," ")) But the second statement isn't working. Any suggestion.

Hello, I am knew to the thread and requesting any possible assistance on a formula. I have a workbook that has 15 worksheets. The first worksheet contains information contracts with that I have to manually input on the applicable worksheets-based on their project. I would like to use a formula...

I have a rate in G9 on TAB 1. I have ranges on TAB 2. This is what I need: If this rate is within the min (A2:A14) and max (B2:B14) of the values in the table on TAB 2 then choose the amount of the corresponding fee in column C (C2:C14). VLOOKUP would be perfect only that the output of the...

Can someone tell me what the symbol ^-1 means as I am trying to work out a formula =IF(ISERROR((((B7*0.48888)^-1)-(371^-1))^-1),0,(((B7*0.48888)^-1)-(371^-1))^-1)

Hello Everybody, Currently I am working with a spreadsheet where I have to collect addresses of UK business Directors. Some of the directors have multiple addresses. UK zip code consist of two segment and I have to ignore the address where the first segment of zip code starts with W1 , SW1...

Need some help I want to have Column A auto fill based on what zone is entered in A1. I am having some problems right now as my formula has become really long the way I been trying and does not work for all Zones. is there an array or another type of formula? <tbody> Thanks...

Hi All, I have a sheet with columns Amount, City and Name. I have a set of names for each location ex: North - Mr.X, Mr.Y, South - Mr. A, Mr. B, East - Mr. D, Mr.F. And a few cities in each of the locations Like North - Boston, Detroit Etc. Can Anyone please help me to provide a if condition...

<tbody> Z Y X A 10 B 4 C 7 D 2 </tbody> Hi, Could you please help me develop a formula for each row as per condition below. In each row: There is only one cell with value greater than >0. I want to use a formula for each row that picks up which column has a value >0 and then...

hi all, iam new in excel, so dont have knowledge about it. I have the situation: columns with 11 digit numbers. WE need to break it 5-4-2. I need to remove the "0" when it is the first character of 5, then 4, then 2. So i came up with this: =REPLACE(B9,SEARCH("0",B9,6),1,"") FIRST OF...

I'm pretty new to excel, so I don't know exactly what's going on here or why, but I have this massive formula...

Hi All, I'm hoping someone can help here. I want to write a formula in Sheet 1 J2 that says: If C2 Sheet1 matches with B3 Sheet2 then the number in C3 Sheet2 should populate in J2 Sheet1 Thanks, Calibre16

We are trying to find subcontractors we did not pay for Job 5202, but we got paid for Job 5202. Column A is Yes or No (Did we get paid for the work order) Column B is Yes or No (Did we pay subcontractor for that work order) If B2 is No, I'd like to highlight it green only if A2 is Yes...

how do i produce a formula that performs what a stock change movement 'up' or 'down' will do? i.e. stock price is $10 in the initial instance; stock price moves to $12 in the next instance reflecting a +2 value in change. I want to write a formula that will juxtapose two different instances of...