ifor

Can anyone tell me why this code will return N/A even though when I walk through it the steps look like it should return an actual result? =IF(OR($I$3="RHP",$I$3="LHP",VLOOKUP($G$3,STATS19pitch,16,FALSE)),VLOOKUP($G$3,STATS19sb,15,FALSE))

I have 4 invoices across multiple sheets (new sheet added monthly) and I want to create a master sheet with all part numbers on it. So I don't have to go through the invoices manually and transpose the cost, is there a way to use either IF(OR or INDEX(MATCH to pull the data from any of the...

Based on an alpha value in A3 and a selection from a drop down in I3 (NO, FULL, PART), I want a numeric value placed in K3. I have this working until I change my IF(AND to an IF(OR and IF(. The first example works and the second one returns a false on the red line when PART is selected (FULL...

Hello All I receive an excel file where a cell would contain a series of acronyms separated by a comma. Is there a formula that will return a result if a portion of a cell equals the query, or will I just have to stick with text to columns and then an if(or statement. Example: <tbody> A B C...

Good Afternoon, I would like some help on a formula for IF(OR. I have attached the spreadsheet for reference. I would like the formula to do two things: 1. when the category drop-down menu is on ALL. I would like it to display all the results on cell C7 and C8. 2. If a date is not available...

Hello, I have seen this answered before, however I have not been able to get the function to work correctly for me. I really appreciate any help that can be given and apologize if this is too similar to something else. I am looking for a formula that will look between ranges to return a value...

How can I write a formula to display data as per the below? The 239.555 is cell C2. The months going horizontally start from E3, going vertically they start from B5. In E5 I am up to here with the formula (needs to be dragged across and down) so as to apply the pattern below to each row...

Morning, I have the following algorithm: <TBODY> N</SPAN> Y</SPAN> Y</SPAN> N</SPAN> Y</SPAN> Y</SPAN> Y</SPAN> </TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP> The part I have bolded repeats infinitely afterwards. I need to convert this into an excel formula. Where a 'Y'...

Column A contains numbers that I want to SUM. But only if they correspond to cells from EITHER of any other columns that contain a word. For instance A1 = 100 A2 = 50 A3 = 25 A100 = 5 B1 = max B2 = (empty) B3 = (empty) B100 = (empty) C1 = (empty) C2 = maxwell C3 = (empty) C100 = the max...

I keep forgetting my syntax in Excel (don't use it enough). I know this is easy; can someone help me to do the following? if cell a2 = "Year" then show a1 times 12, if cell a2 = "Half Year" then show a1 times 6, if cell a2 = "Quarter" then show a1 times 3, if cell a2 = "Month" then show a1. I...