logic

afternoon all, a silly one, but am lost... my formulae is =countifs(Conversion!C:C,D18,Conversion!F:F,E18,Conversion!J:J,F18,Conversion!P:P,G18,Conversion!M:M,H18,Conversion!Q:Q,I18) What i am doing here is countifs if each column includes a referenced profile criteria.... and its stopps...

Working on a table where i have a cell that eventually will have "yes" entered in it. once Yes has been entered a date is then entered. Can i use a logic test where when "yes" is true it inserts the date? this is what i have now ... =IF(V17="yes","d/mm/yyyy","") but d/mm/yyyy is what comes...

Can I use logic operators in the array section of a sum(countifs formula? Example: =Sum(Countifs(item.range,A3,location.range,B3,date.1.range,{"<"&A1,">"&Eomonth(A1,0)}) A1 is a date, typically the 1st of any given month. I have tried it and it doesn't seem to work as expected. Any...

Hi all, I have been handed a spreadsheet that has thousands of names and addresses extracted from a SQL database. Each row also includes columns for their partners name (if they have one) My problem is that if Mr John Smith has a partner (eg, Mrs Janet Smith) showing in the same row, then...

Hey everyone, I am trying to get the following Nested IF Function to work, but my brain has a hard time putting the logic together. IF(D35<500,0,(IF((E35/F35)-1)<-.50,-.50,IF((E35/F35)-1)>.50,.50,(E35/F35)-1)) I am basically just looking to set an upper and lower bound if there are more than...

Hi mate I have some data as below <tbody> Orange Juice Orange Add Mango Jam #VALUE! Filled up Coffe #VALUE! Maybe repost #VALUE! </tbody> and I want to Search some word with some logic as below...

Evening all! Im trying to create a new spread sheet and well, iv come accross my brain block.. you can see in the spreadsheet attatched. http://s000.tinyupload.com/?file_id=84408271285290770767 Im trying to write a formula that will populate the 'F' (forcast) Column with the Weekly Spend over...

Hello - I have the following formula =ROUND(IF(F$21=TRUE,$T$13*(MAX((F43-$C$78),($C$59))+($C$61))*$C$60,0),0) F43 is the annual premium C78 is the subsidy amount C59 is the minimum C61 is the surcharge C60 monthly pay frequency I need to add the following logic to the max formula if C71 =...

Hi, I need to return a value in a cell based on 2 pieces of information/criteria being true. I have 3 job roles SrCTM CTM CTA I then have 5 possible values 1,2,3,4 or 5 in a second cell. I need the result in the final cell to be dependent on if (A1= Sr CTM and C2=1,2,3 etc) then it returns...

I can't figure out what the vectorization is in DAX If I have a calculated column based on a slicer like =Slicer[field] Of course that doesnt' work. I don't know why, but you need to wrap it in: =Values(Slicer[field]), probably because Dax tries to combine its column logic and its aggregation...

All, I am doing a sum(if( and then using the array to do the logic. =SUM(IF(ISNUMBER(B5:B662),IF(INT(B5:B662)=INT(R5),--((E5:E662>220)+(F5:F662>220)+(G5:G662>220)+(H5:H662>220)>0)*(D5:D662=1)))) I want to add more logic to this. so it will be column D =1 and Column k<20 and Column L<20 and...

Hi Team, I'm struggling with rounding off scenarios in Excel. Can you help me with the below problem statement. Data- <tbody> Customer Location Sales Qty (MT) Possible Truck Type Truck Type Truck Type(Tolerance) X 20.3 15,20 Y 18.3 16,20 Z 9.9 10,15,20 </tbody> Output...

Can someone explain why in the formula: =COUNTIFS(Sales,">="&H1,Sales,"<"&G2) quotes are used? I know about concatenation but why are the logic signs in quotes and why couldn't the formula just as well be written as: =COUNTIFS(Sales,>=&H1,Sales,<G2) ??? I know words that appear in quotes...

I would really appreciate some help!! I am trying to figure out how I can accomplish the following logic: I have files that are assigned to one person, and can switch assignments. I need to locate these switches for specific people. My sheet will look something like what is shown below. The...

Hi folks, This one may be tough, if possible at all. I have my file here if you need it: RSC Billing Template_8-23-17_Test.xlsm - Google Drive The formula I need is going to be in the H column, Insurance Company, from H6, down to row 500. I am not sure you can do this with so many '...

Looking to see why this isn't working, both x and y are Integers I am really hoping this is simple, but I have this segment with nested in my code and when doing it step by step or F8 and when I run it normally its not working. Like if x = 8, it specifies y = 7 which is totally not right; and...

Hello All, I am working on one logic , need help i have a range Range A:AE Have Certain codes (alphabets) on cells like "P" , "SL" , "TL" , "MK" i want to apply logic that starting from cell A1 or A2 or A3...... macro should check for code "P" in cells , as soon as it finds 6 "P" in a row (No...

Hello, it will be a stupid question most probably... Why in VBA we are using the following: "If Not Selection.Value > "" If I'm correct that this basically means "if selection value is not bigger than nothing", which mean if value is 0.. There is no "If Selection.Value = "" for this or why...

Can someone help me on below formula, used to populate unique values from a Range "NAME", present in DEPT "Science" MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0) Complete Formula: {=INDEX(NAME,MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0))} Note: This formula is used in...

Hi, If I create a macro and run it on a file (script would entail some vlookups to repository files, text-to-columns, etc.), do I have to re-run that macro every time I add information to the existing file and save it (added information with the same format, column names, etc.), or can I...