Re: Closing IF Formula?
You are welcome, BUT pls Don't cross post WITHOUT to provide a link for this.
Posts by Fotis1991
-
-
Re: Confusing IF statement problem
Never mind. Let us know.:)
-
Re: Confusing IF statement problem
No error for me.
-
Re: Closing IF Formula?
IF(B4>((C4-B4)/0,25),""))))
This is the last part of your formula in row 4.
So (C4-B4)/0,25) =0.04 In this case, the value inB4 is greater than 0.04. So correctly formula gives nothing("") as result.
The point is: Do you really need this condition?
-
Re: Confusing IF statement problem
Perhaps an If in front of your formula?
=if(b33=0,0,If(F43>=F46,B33,If(F43<F46(F46-F43),0)))
-
Re: Closing IF Formula?
i think that you have to upload a small sample workbook, explaining in this the expected results.
-
Re: Create Correct Average of values including N/A
Try
=SUMIF(B1:F1,">0")/COUNT(B1:F1)
-
Re: Closing IF Formula?
This formula works but i don't know if gives you the expected result.
=IF(ISBLANK(P7),"",IF(P7<0,Q7="0",IF(H7>0,(H7-P7)/0.25,IF(I7>((P7-I7)/0.25),""))))
If the red part of the formula is zero and not the letter O, then you don't need these " "
-
Re: greater than 3 conditional formats WITH an IF statment
As i told you in the other forum, don't cross post without a link.
-
Re: Insert Date of Last Payment
Try in G4 and copy down this ARRAY formula.
=LARGE(IF(B4:F4>0,$B$3:$F$3),1)
-
Re: How to combine calendar array with a vlookup formula
You are welcome and thanks for the feed back.
Pls, let also the other forum members to know that you found your solution.
-
Re: How to combine calendar array with a vlookup formula
...And the attachment..
-
Re: How to combine calendar array with a vlookup formula
Quote...Please find attached if you can perhaps make this work for me
Yes this one i can.
=IFERROR(VLOOKUP((MOD((F18-StartDate)/28;1)*28,1)+1;ROSTER_LOOKUP;Sheet2!$C$6+2);"")
-
Re: How to combine calendar array with a vlookup formula
You can not have the result of 2 different formulas(eatch of your formula gives a completely different result) in a single cell.
My VBA skills are not good so i don't know if you can do this using VBA.
-
Re: How to combine calendar array with a vlookup formula
Hi
1) Can you upload a sample workbook?
2) Pls, provide the link of this thread to the other forum as you did here.
-
Re: Multiple Sheets & Summary
Try these formulas copied down
=COUNTIF(Sheet2!$A$2:$A$1000,Sheet1!A2)
=SUMIF(Sheet2!$A$2:$A$1000,Sheet1!A8,Sheet2!$E$2:$E$1000)
-
Re: Multiple Sheets & Summary
QuoteDisplay More...THIS IS ON A SEPARATE SHEET
[tr]
SHEET 2
[TABLE="class: cms_table"]
[td]ITEM
[/td]
[td]Duration Total
[/td]
[/tr]
[tr]
[td]Item A
[/td]
[td]0:24:33
[/td]
[/tr]
[tr]
[td]Item B
[/td]
[td]0:08:32
[/td]
[/tr]
[/TABLE]Are these the expected result? I mean the results that you want to see in your second sheet?
Pls, upload a sample workbook.
-
Re: Paste from excel into form.
It is an honor for you that you understand and agree with what we told you.
As Citop offer you the solution to your problem, I will suggest you to also inform the people in the other 2 forums that you found the solution.
-
Re: Need formula for data fetch in column and row simultaneously
You are welcome.
Thanks for the feed back.
-
Re: using COUNTIFS or nested IF's to count only unique values
Trying to keep it simple, give a try to this.
In an empty column(I used column B), starting in row B-B2 in our example and copy down, use this formula.
=SUMPRODUCT(($A$2:A2=A2)*($J$2:J2="ORG")*($P$2:P2="West"))
This will be a helper and hidden column.
Then use this one to get your result.
=SUMPRODUCT((J2:J1000="org")*(P2:P1000="west")*(B2:B1000=1))