ifandor

So I am Struggling with finding a way to have a formula that will search column C for certain words that will then categorise them into column D. For example with the text cell C2 contains "Zoom" Cell D2 = Software, Cell C3 contains Zipcar cell D3 = Travel, C4 Contains " Voxi", D4 =...

Hello, For a document at work I need to calculate the total days that we have had someone stay at our property. Something that should look like below. Room Room (per person) Date in Planned Date Out Actual Date Out Total Nights 1511 1511 25/09/2020 9/10/2020 7 1511 25/09/2020...

<tbody> w x y z aa 8 251 -108 159 9 -231 118 -149 10 </tbody> What is the correct way to enter the following multi step fx to satisfy the following: In cell Z8 = IF W8 is > 0 AND X8 < 0, OR IF W8 < 0 AND X8 > 0, AND X8 <=-150, THEN 1, "" In cell AA8 = IF W8 is > 0 AND X8 <0...

<tbody> A B C 1 23 -145 1 2 -71 140 3 35 130 1 4 -22 -127 </tbody> How do you write a proper IF(AND(OR fx in cell C1 that I can drag down thru C4 that states: if the number in cell A1 is >0 and <50 AND the number in cell B1 is >-150, <-109 *OR* >109, <150, then cells C1 populates...

Hi, I have the following formula: =IF(AND([@[Received_Date(Final)]]<>””,[@[Received_Date(Final)]]<today(),trim([@[status_name]])<>”Completed”),TODAY()+TIME(7,0,0),[@[Received_Date(Final)]])</today(),trim([@[status_name]])<> Basically the formula moves a date to today’s date if the status name...

I would like to create a custom function for use within an IF(AND(OR . . . formula, but I have no idea how to convert specific cell references into generic form or how to refer to cells in the preceding row, or in fact if what I'm trying to achieve is even practicable; maybe I've totally...

I know there is any easier way of doing this by combing if(and(or statements, but I did it the long way. How can I combine all of these IF Statements to 1 formula? IF((AND($A41=1,$B41=0,$C41=0,$D41=0,$F41=0,$G41=0,$H41=0,$I41=0,$J41=0)),"Step 1","")...

I have tried a few combinations but cannot get the end state I am trying to combine these two equations. I've tried using IF(AND(OR without luck. Again thanks for the help! =IF(AND(D2="10k",E2<=120),"Go,"No Go") =IF(AND(D2="20k",E2<=240),"Go,"No Go")

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...

I am trying to perform a conditional sum for something similar to the following data. I have some part numbers in the first column and the weeks in the first row and some data. What I am looking for is, for each month, if the data values start in that month, I want the sum of "Total". So, for...

I have been tasked with populating a 4th column in worksheet (Color Number) with a number referring to a match in a table of colors with the number. I was wondering if there was a quick easy way to auto populate the 4th column based upon a match from my worksheet and the table I am working from...

Ok, here it goes: <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0...