Hi in this excel sheet I want to put formula if MFD+Expiry is greaten than EDATE(B8,24) then EDATE(B8, 24)) if its less then Reference cell H8
Hello, I am having trouble trying to formulate this. My current formula is =IF(AND($C$7>=1.2,$C$7<=1.2),SUM(F6-$D$7)) which works...
Forum Discussion Hi, Kindly help me the IF condition with Addition formula. Ex IF(Sheet1(range)="sheet2A1", If this condition is true then , "Sheet1 b1+shee1 z1", If its false then" test". Here i attached the sam... Your sample WB has only one sheet and,, If Sheet1(Range,,...
{"__ref":"User:user:722750"},"revisionNum":1,"uid":1728351,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: If Condition with text and multiple options","readOnly":false,"editFrozen":false,"moderationData":{"__ref":...
Forum Discussion Dear Friends, Kindly help me the below error, i have written the IF condition like 0.50 > GREEN, Refer the column - j2>=0.50, t2>=0.50, "green", 0< RED, Refer the column - j2<=0, t2<=0, "re... Well, with this data it seems that OR in all three conditions...
Hi, I'm trying to create a column that will calculate a value based on a risk matrix; I have come up with the formula below, but it's not working. I've also tried a switch formula without success. I'... TPalmer1695You are using more than 19 nested IF functions in...
Dear Friends,Please help me out for the below issue. I have a DATEDIF value, and on which the IF condition is not working. But if I change the DATEDIF value...
In summary, the formula checks for number "1" in table column "TEAM" (column E), and if so, then checks the time is between table column "STA" and "STD", then returns the value 1 if true. There is then conditional formatting looking for "1" and turns green if f...
I have applied sumif formula and drag down, the formula went all and got the result as well. While deleting formula in specified cell or applying other...
In the "Format values where this formula is true" field, enter the following formula: =COUNTIF('Closed POs'!$A:$A, A1)>0 Note: Replace 'Closed POs' with the actual name of your second tab, and adjust the column references as necessary. ...