if funcions combination

How to solve the error in below formula.. ?? $S2=”Billable Only”,”BILLABLE ONLY” when inserted in formula shows error. Rest of the formula works fine. =IFS($V2="YBWR","What",ISNUMBER($Y2),"Fully Delivered",$S2=”Billable Only”,”BILLABLE ONLY”,AND(ISBLANK($Y2),NOT(ISBLANK($AA2))),"Under...

Hi, I'm trying to find a medication displayed on sheet 1 within a list of medications (displayed on sheet 3) and output its relevant usage (relevant totals cell displayed on sheet 2) - for example if Allopurinol 100mg tabs is the medication displayed on sheet 1, then the quantity cell should...

I have two different columns on different worksheets that I want excel to count. currently I am unsure on how to add another logic to this formula please help. So basically I want excel to count if 'Upload New Class'!$B$2 is found in table 1 with range's X-Z OR table 2 with ranges X-Z...

Hello, I am looking for help with a formula to return a unique value once Excel has found a match. I will try and explain as best as I can. I have a column (Column A) in a master worksheet (Worksheet A) that compares two columns from two separate worksheets (Worksheet B and Worksheet C)...

Hello guys, I have a difficulty finding the right formula for my problem. I started my vlookup with many if's but didn't work. Choose function didn't work eather. I have to search for the correct owner based on multiple conditions: 1. If the ProductBrandCode is AB_N00, AB1_N00 or AB2_N00 (or...

Hi there, I am trying to create a new column in my dataset that will display a "yes" if ANY of the three criteria are met and a "no" if none of the criteria are met. For example if someone participated in year 1 and scored a 2 or above OR participated in year 2 and scored a 2.5 or above OR...

Hello. I am trying to get A,B,C,D to appear based on a different cells value IF U7 is less than 5; then "A" IF U7 is less greater than 5, but less than 20; "B" IF U7 is greater than 20; then "C" IF U7 is "N/A" (from a vlookup); "D" This is what I have now and it works for the "C" but returns...

=IF(A1="DEMAND",0,IF(A1="COLLECTION",0,IF(A1="BALANCE",IF(O1<=Y1,O1,IF(O1>Y1,Y1,0))))) I am using the above formula, I want a simple change over there, in the last part IF(O1<=Y1,O1,IF(O1>Y1,Y1,0) I want that If O1<=Y1 then O1 and if O1<0 then result will be zero, I want to add this part in the...

I was hoping someone could help me with a formula based on a certain scenario. <colgroup><col><col span="2"></colgroup><tbody> Organization Product Name Total $ American American o $6,564,132 American American Inc $3,647,234 American American CIB $443,245 American American Wash...

Hi, Posting a few times today, sorry. I need a formula which will do the following. I have data in columns going along my worksheet, roughly 10,000 rows. I need to be able to SUM some responses based on more than one factor. Column R has the location of response e.g. London, Glasgow etc and...

The current formula: B2 is a given number. I enter C2 and the below formula calculates D2 based on the following: For every 2 units higher that C2 is than B2, D2 will go up 1. For every 3 units below that C2 is than B2, D2 will go down 1. Below is that formula that is entered into cell D2...

Hi Everyone :) Having trouble putting the following statement together. I have various dates in column A and column B with some blanks mixed in. I need a statement in column C that will show the earliest date between column A & B. If both columns are blank then I need a return of: "Still in...

Ok, what i need it this The overall condition to be checked is K15270=H15270 If M15270="only #", then write "same #" BUT IF M15270="Text", then write "same original" if K15270 is not equal to H15270, then write "-" My attempt: =IF(K15270=H15270,IF(M15270="only #","same...