# Posts by Fotis1991

• ## Confusing IF statement problem

Re: Confusing IF statement problem

Never mind. Let us know.:)

• ## Confusing IF statement problem

Re: Confusing IF statement problem

No error for me.

• ## Closing IF Formula?

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?

• ## Confusing IF statement problem

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

• ## Closing IF Formula?

Re: Closing IF Formula?

i think that you have to upload a small sample workbook, explaining in this the expected results.

• ## Create Correct Average of values including N/A

Re: Create Correct Average of values including N/A

Try

=SUMIF(B1:F1,">0")/COUNT(B1:F1)

• ## Closing IF Formula?

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

• ## Insert Date of Last Payment

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)

• ## How to combine calendar array with a vlookup formula

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.

• ## How to combine calendar array with a vlookup formula

Re: How to combine calendar array with a vlookup formula

...And the attachment..

• ## How to combine calendar array with a vlookup formula

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);"")

• ## How to combine calendar array with a vlookup formula

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.

• ## How to combine calendar array with a vlookup formula

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.

• ## Multiple Sheets & Summary

Re: Multiple Sheets &amp; 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)

• ## Multiple Sheets & Summary

Re: Multiple Sheets &amp; Summary

Are these the expected result? I mean the results that you want to see in your second sheet?

• ## Paste from excel into form.

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.

• ## Need formula for data fetch in column and row simultaneously

Re: Need formula for data fetch in column and row simultaneously

You are welcome.

Thanks for the feed back.

• ## using COUNTIFS or nested IF's to count only unique values

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