# Posts by Ingo_Ingo

Quote

=IF(Specific cell="","",Original formula), etc.

Try:

=If(a687="",0,IF(WEEKNUM(A687,21)=WEEKNUM(B687,21),WEEKNUM(A687,21),WEEKNUM(A687,21)&-WEEKNUM(B687,21)))

or

=If(or(a687="",b687=""),0,IF(WEEKNUM(A687,21)=WEEKNUM(B687,21),WEEKNUM(A687,21),WEEKNUM(A687,21)&-WEEKNUM(B687,21)))

Hi,

If your DOB 13-06-1973 is in A2, then in B2 put this formula:

=DATE(YEAR(A2)+59,MONTH(A2),DAY(EOMONTH(A2,0))) Common sense is not so common! Or ="Q"&INT(MONTH(TODAY())/3)

Code
1. Sub TestPreviousQuarter()
2. MsgBox Evaluate("=""Q""&INT(MONTH(TODAY())/3)")
3. End Sub

Hi,

use =IFERROR(B2*C2,0)+IFERROR(D2*E2,0)+IFERROR(F2*G2,0)+IFERROR(H2*I2,0)

Hi,

Try this:

Code
1. Sub Loop2()
2. Dim Rw As Long, Cl As Long
3. Range("C2").Select
4. Do
5. ActiveCell.Formula = WorksheetFunction.Average(ActiveCell.Offset(, -1), ActiveCell.Offset(, -2))
6. ActiveCell.Offset(1, 0).Select
7. Loop Until IsEmpty(ActiveCell.Offset(0, -1))
8. Range("A22").Select
9. End Sub

The formulas given by me do not produce that zero.

However, those zeros can be removed with conditional formatting or Custom Format.

Hi,

In sheet SETUP

In E4 use this formula:

=IF(\$B\$4="","",INDIRECT(\$B\$4&"!G"&ROW()+3)) and drag down

and in D4 use this formula:

=IF(\$E4="","",IF(LEN(\$B\$4),INDIRECT(\$B\$4&"!"&"F"&ROW()+3),"")) and drag down

In sheet Material1, Material2, Material3

In F7, then drag to G7 then drag down, this ARRAY FORMULA:

=IFERROR(INDEX(B\$7:B\$26,SMALL(IF(\$D\$7:\$D\$26="y",ROW(B\$7:B\$26)-ROW(B\$7)+1),ROWS(\$F\$6:F6))),"")

Hi,

In A2 use this formula:

=VLOOKUP(B2,\$F\$2:\$H\$13,3,1) and drag down.

Hi,

For Lyra in column H, what is corect answer Beijing or Geneva or both?

Hi,

Change your Private Sub cmdOpen_Click() with this:

Private Sub cmdOpen_Click()
Dim sFilePath As String
sFilePath = "C:\Users\jchan\Documents\My Documents\NHRA\Chassis Inspection Info\Chassis Specs\Chassis Specs" & cboChassisSpec.Text

End Sub

Maybe now someone could help...

Thanks for the answer, but I do not see how it could help me, that link.. I know that site.
I do not have access to the source file - it is "read only" - I would have wanted a code to do the processing - in memory - and then write it directly to the file where I run the code.
It seems difficult if nobody could answer.

Hi,

I think it's too complicated ...