C RUBY-ON-RAILS MYSQL ASP.NET DEVELOPMENT RUBY .NET LINUX SQL-SERVER REGEX WINDOWS ALGORITHM ECLIPSE VISUAL-STUDIO STRING SVN PERFORMANCE APACHE-FLEX UNIT-TESTING SECURITY LINQ UNIX MATH EMAIL OOP LANGUAGE-AGNOSTIC VB6 MSBUILD

# Excel tricky formula

By : user2954820
Date : November 22 2020, 10:33 AM
it should still fix some issue Assuming I've understood what you're asking, I believe the formula you're looking for in cell D4 and copied down is:
code :
``````=IF(C4="","",IF(OR(C4+365>TODAY(),AND(\$H\$5>0,C4+365>=\$H\$5,C4+365<\$H\$5+90)),C4+365,"Rolled Off"))
``````

Share :

## Tricky counting formula

By : Rnew
Date : March 29 2020, 07:55 AM
With these it helps With the following data layout:
code :
``````=100*A2+IF(A2<>A1,1,MOD(E1,100)+(C2<>C1))
``````

## How to convert Array formula of excel file to equivalent regular/normal formula in excel?

By : Karosis
Date : March 29 2020, 07:55 AM
hope this fix your issue Using a helper column the array formula could be avoided:
We are using '02_BillList' column X as helper column.
code :
``````=INDEX('02_BillList'!\$B\$1:\$W\$4000,MATCH(\$A4&S\$1,'02_BillList'!\$X\$1:\$X\$4000,0),22)
``````

## I have an Excel VBA macro that copies/paste and Excel formula to another file. The formula is this:

By : rex realingo
Date : March 29 2020, 07:55 AM
it helps some times This test seems to work on my pc. Change the format in SaveAs:
From
code :
``````wbDest.SaveAs fName, xlText
``````
``````wbDest.SaveAs fName, xlTextPrinter
``````

## Excel VBA Macro Formula Help Regarding not show formula in formula bar

By : Sam Fitzpatrick
Date : March 29 2020, 07:55 AM
hope this fix your issue I want to use if condition formula to calculate the cube via vba macro button. I write code and its working is fine but code is show in formula bar and also working with formula come from vba macro and remain their, I want that this formula did not should be show in formula bar and the calculation should be done only via macro button when i press it. here is my code. , Something along the lines of:
code :
``````Public Sub CubeColumnC
Dim wb as Workbook
Dim ws as Worksheet
Dim sourceRange as Range
Dim sourceArr()
Dim i as long

Set wb = ThisWorkbook
Set ws = wb.Sheets("Sheet1") 'change to as needed
Set sourceRange = ws.Range("C3:C21")

'Assign column c values to array
sourceArr = Application.Transpose(sourceRange.Value)

With ws
For i = Lbound(sourceArr) To Ubound(sourceArr) 'Write back out to col D
If .Cells(2+i, "C") = vbNullString Then   'if blank
.Cells(2+i, "D") = "-"
Else
.Cells(2+i,"D")  = sourceArr(i)^3 'Calc the Cube value
End If
Next i
End With
End Sub
``````

## Multiple If conditional formula but tricky one

By : Abbas Mostakhdemin H
Date : March 29 2020, 07:55 AM
To fix the issue you can do Excel Column M = start time and Column N = End time , Use a nested IF, but change the logic a little:
code :
``````=IF(AND(M2="",N2=""),"Not Started",IF(N2<>"","Completed","In Progress"))
``````
``````=IF(N2="",IF(M2="","Not Started","In Progress"),"Completed")
``````