Excel function: "Not Isblank" with "Or" and if date is 
I can’t really test this due to how Excel localizes its function names
(which is so stupid…), but you should be able to combine multiple
booleans with AND or OR, depending on which behavior you want.
If you want to check if two cells are empty you can use AND(ISBLANK(H4),
ISBLANK(H5)) as the condition; if you want to check if both are not empty,
you put all that in another NOT: NOT(AND(ISBLANK(H4), ISBLANK(H5)).
Similarly, if you want to check if at least one of the cells is empty, you
can use OR: OR(ISBLANK(H4), ISBLANK(H5)). And if you want to check if none
of the cells is empty, you can again again put that in an AND.

Inspite of setting (null=True, blank=True) for ModelForm field, I get validation error on leaving the field blank 
Set the field to required=False
class MyForm(ModelForm):
filing_date = DateField(input_formats=['%d%m%Y'],
widget=DateInput(format=('%d%m%Y'),
attrs={'class':'inputblocklevel datePickBootstrap', 'placeholder':'Filing
date'}),
required=False)
class Meta:
model = try

Migrating ManyToManyField to null true, blank true, isn't recognized 
That behavior is correct: null doesn't mean anything at the database level
when used with a ManyToManyField. The invocation of a ManyToManyField
causes the creation of an intermediate table to hold the relationship, and
although Django will create a standard attribute on your model instance for
your convenience, there is no actual column representing it that could be
nulled. By definition there can always be zero instances of the
relationship.
blank=False, though, does have an effect on the admin app, forcing the user
to choose at least one relation.
(Note that Django's builtin migration system creates migrations for just
about any change to a model, regardless of whether it affects the database
or not. So this change would lead to a migration, but it wouldn't affect
the database or whe

For an Excel Formula's variable taking a Range, input row number by the result of a formula 
Try using the INDIRECT function:)
say you have three cell that can dynamically calculate the address of your
input range.
something like what you suggested and it is in the cell A1
="$BB$2:$BB$" & COUNTA(BB2:BB1000) > in cell A1
You can use the Indirect function like this:
=SERIES(INDIRECT(A1),[RANGE],[RANGE])
Hope this helps!

Excel formula > how to change SUMPRODUCT formula to skip null cells 
In the sumproduct, to exclude empty cells, suppose you're using it on range
A1:A100, you could do the following:
= Sumproduct((A1:A100),(A1:A100<>""))
That second criteria will ensure that you're only looking at cells that
have a value in them...
As an explanation (A1:A100<>"") will return an array of True False,
where, if there is a value in the cell, it returns true, otherwise, false.
Then, including the  before it, it converts True/False to 1/0. So, in
effect, you're multiplying empty cells by a zero (excluding from the
formula) and nonempty cells by 1 (including them in the formula).
The (logical statement for my array) is a very useful trick to use with
SumProduct() in MANY different ways!!

Convert Java/C style formula to excel formula 
You can use built in Excel functions to substitute desired strings instead
of other determined strings, such as:
=SUBSTITUTE(D2,"AND"," == ")
You can also read the formula into a string in VBA, perform the same
operation, and place the formula back in excel. The
strFormula = Cells(2, 4).Formula
strFormula = Replace(strFormula, "AND", " == ")
Cells(2, 4).Formula = strFormula
I hope this helps.

SQL Formula Answer is Different from Excel Formula 
Firstly, the question is tagged with MySQL, but the syntax used looks
suspiciously like SQLServer, as such I will do all the demonstrations with
SQLServer syntax.
Secondly, based on the magnitude of the error (to the order of 10), I think
you have your calculations mixed up, you appear to be saying that in the
below 3 columns
sum ([Impacts]) as 'column1',
sum (nullif([Resp 2],0)) as 'column2',
sum (nullif([Resp 2],0)/nullif([Impacts]*1000,0)) as 'column3'
the third column is not giving you the same result as if you did the
(column2 / (column1 * 1000) in excel, however this is not the same formula.
I think what you need is:
NULLIF(SUM([Resp 2]), 0) / (NULLIF(SUM(Impacts) * 1000, 0) AS [Resp 2%]
Imagine this simple example (I have removed the NULLIF operators to make
the difference

In Excel, how to fill blank cells with the last preceding nonblank cell? 
In a "manual" fashion, you could do the following:
Select the column, go to Edit > Go To > Special > Blanks, type = in the
formula bars, hit the up arrow then Ctrl+Enter. you should now have the
cells fill with the values above
In a more "automated" fashion using VBA, you could do the following:
Select the range where you want to fill the blank cells,
Then click on Developer Tab > Visual Basic > Insert > Module
Then paste the code in the Module, and click on run:
Code:
Sub Fill_Blank_Cells()
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "=R[1]C"
End Sub
As @Jerry rightfully pointed out, make sure to copypaste special the
values in order to remove the formulas behind your filled column. This will
prevent any undesirable results later!

Generating a new Excel while retaining old formula from template Excel file 
If you have access to the Cell, simply call:
String formula = cell.getCellFormula();
Note though that this will only work if the cell is formula cell. IE:
cell.getCellType() == Cell.CELL_TYPE_FORMULA. If the cell is not a formula
cell, you're going to end up with an IllegalStateException as described in
the API

Excel VBA Formula not working in German excel 
This wouldn't work under English locale, too. * & is not a valid
sequence of operators.
My psychic powers tell me you want to embed Calc into the formula as a
literal, in which case it should be
Range("A2").Formula = "= B2 *C2 * " & Str$(Calc)
You have to use Str to have Calc converted into a string according to the
English locale, required by Formula. You could leave it as is if using
FormulaLocal.

How do I use this boolean.  isBlank 
You can do this in single line.
if(edittext.getText().toString().trim().length()>0){
Syste.out.println("Not Blank");
}else{
Syste.out.println("Blank");
}

How to make format() yield numeric objects 
Format returns character vectors, so this is in general to be expected.
Your problem, I think, results from the fact that the "format"
representation of an integer vector c( 1, 2, 3) is "1" "2" "3", whereas the
representation of a numeric (real) vector c( 1, 2, 3 ) is "1e+00" "2e+00"
"3e+00".
Consider the following:
format( 1:10 )
format( 1:10, scientific= TRUE )
format( as.numeric( 1:10 ), scientific= TRUE )
Therefore, try
format( as.numeric( table( example ) ), scientific= TRUE )
Unfortunately, you cannot omit the as.numeric, since table generates
integer values, and you need real.

What does PrincipalContext.ValidateCredentials return true for blank passwords? 
From MSDN http://msdn.microsoft.com/enus/library/bb154889.aspx
The ValidateCredentials method binds to the server specified in the
constructor. If the username and password parameters are null, the
credentials specified in the constructor are validated. If no credential
were specified in the constructor, and the username and password parameters
are null, this method validates the default credentials for the current
principal.
In the PrincipalContext constructor you could specify the credentials you
want to check as well.
using (PrincipalContext pc = new PrincipalContext(ContextType.Domain,
domain,
container, ContextOptions.SimpleBind, username,
password))
{
return pc.ValidateCredentials(domain + @"" + username, password,

Does PHP if statement assume you are checking for 'true' if left blank? 
if($variable)
is pretty much saying
if($variable != null && $variable != false && $variable !=
0)
So as long as the variable is set and not equal to 0 or false it will be
evaluated as true
"and if so is it 'good programming' to leave it blank or should you finish
off the statement for the sake of not cutting corners?"
if you are trying evaluate exactly equal to true, it is cutting corners,
but it is pretty common to use if($variable) to confirm that $variable is
defined with a value

set sum formula in excel using vba 
Try something like this.
For cl = 2 To 5
ColName = Left(Cells(1, cl).Address(False, False), 1  (cl > 26))
Worksheets(5).Cells(4, cl).Formula = "=SUM(" & ColName & "4:"
& ColName & "6)"
Next cl

If/Then Excel Formula 
You need to put your return values inside quotes, otherwise Excel assumes
that TP is a valid name in the workbook (i.e., an address, named range, or
variable).
=IF(A2="160850","TP",IF(A2="202006","BL",IF(A2="203646","MM",IF(A2="203917","KT",IF(A2="200265","MP",IF(A2="201447","JB",IF(A2="170566","VB")))))))
There may be additional errors, but this one is apparent.

understanding and excel formula I have been using 
1048576 (2 to the 20th power) is the maximum number of rows in a worksheet
in Excel 2007 and later. (In previous versions, it was 65536, or 2 to the
16th power.)
Basically, the N$1:N$1048576 refers to "all the cells in column N".
However, for safety reasons, you should change that part of the formula to
the simpler N:N  in fact, if I copy your formula, click on an Excel cell,
and press Ctrl+V, Excel does that replacement automatically.

Excel formula for just MF and TS of each month 
Well, sure, you can use this formula to avoid the blank cells in between
the dates:
=IFERROR(INDEX($A$1:$A$31,SMALL(IF(MOD($A$1:$A$31,7)>1,ROW($A$1:$A$31,9^99),ROW())),"")
This formula (for Monday to Friday) needs to be called with
Ctrl+Shift+Enter. After doing this for the first date, you can drag down to
the bottom.
For the one with Tuesday to Saturday, it's a bit longer;
=IFERROR(INDEX($A$1:$A$31,SMALL(IF(((MOD($A$1:$A$31,7)>2)+(MOD($A$1:$A$31,7)=0))>0,ROW($A$1:$A$31),9^99),ROW())),"")
But at the same time, you have to call this function with Ctrl+Shift+Enter
as otherwise, you won't be able to get the other dates (you will get #NUM!
instead for the other dates).

MS Excel Formula Correction 
If it is acceptable to use Visual Basic for Applications (VBA), create a
macro and define the following function in it:
public function GetCode(s as string) as string
GetCode = ""
codes = split( _
"SIPCHIUGMCCNSLCSMRoHCGL1GL3GL2URRCUPHYUHALUMAC", "")
for each code in codes
if InStr(s, code) > 0 then
GetCode = code
exit for
endif
next
end function
You should then be able to access the function in your formula as follows:
= GetCode(J2)

Excel formula with OR and AND and possible lookup 
The formulas you'll need to use are IF, OR, and AND. Assuming you're
familiar with IF, AND and OR can be used together to evaluate multiple
conditions. In your case, your formula could look something like this:
IF(AND(OR(A1="x",B1="x"),OR(C1="x",D1="x",E1="x")),"YES","NO")
For your other conditions, you can move the OR conditions as you need, or
add/remove conditions within the OR/AND statements.

VBA Excel: not statement & formula 
You will need to give us more code, as the following works:
Public Sub test()
MsgBox Not myfunction()
End Sub
Function myfunction() As Boolean
myfunction = False
End Function

Excel nested IF formula 
Your if statements are backwards you should check for bigger numbers first
in this case otherwise the first if is always true. so 7 is falling true on
>= 3 therefore you get 1 + 1 = 2
EDIT  a better way to do it would be to take your J4 divide it by 3 and
return the value without the remainder
QUOTIENT(J4, 3)

Converting an Excel formula to C 
I am not an Excel function wizard, but am pretty sure the following three
functions
may help: time(), localtime() and mktime(). Each is ANSI C and well
documented. By getting current time, then passing it back and forth between
the functions (either by pointer to struct or time_t value) you can
manipulate or inspect different values for time.
Simple example:
#include <windows.h>
#include <ansi_c.h>
void timeFunc(void);
void main(void)
{
timeFunc();
}
void timeFunc(void)
{
struct tm *today;
struct tm *modified_time;
time_t secCntGMT1900 = 0;
time_t modifiedTime;
// Get GMT time in seconds since 1900
time( &secCntGMT1900 );
// Convert GMT time to local time to local time format
today = localtime( &secCntGMT1900 );
//modif

POI Excel formula translated? 
Take a look at this question.
As stated in the answer, Apache POI doesn't support multiple languages, so
you will have to use the English formulas to make it work.

Why does this Excel formula work? 
To answer the first part of the question  the curly brackets indicate an
array formula (function). The PERCENTILE function is one of them. To enter
the formula you need to use: CTRL+SHIFT+ENTER, pure ENTER is not enough.
You can read more about it here:

MIN INDEX Excel Formula  Where "IF" is a value 
If you don't mind an array function (the first one that came to my mind),
you can use this:
=MIN(IF(S2:S8="Outstanding",N2:N8))
And change the height of the ranges accordingly.
Since this is an array function, you have to use Ctrl+Shift+Enter to make
it work, instead of enter, after typing the formula.

How build formula IF in Excel? 
Not tested, but you can just nest IFs, putting another IF inside the true
or false clause.
Arbitrarily assuming your value of H is in cell A2:
=IF(OR(A2 = "V", A2 = "KR"), 0, IF(A2 >= 7, 1, 0.5))

excel formula non trivial nested OR 
I think you are talking about nested IF statement
Stick numbers 1, 2, 3 in cells A1, A2, A3, then in Cell B1 stick the below
formula and drag it down
=IF(A1=1,"A happens",IF(A1=2,"B happens","Neither A or B"))
And your results

Formula required for recoding in Excel 
I would say to put in E7 :
="VAR" & IF(D7=1,4,IF(C7=1,3,IF(B7=1,2,IF(A7=1,1,0))))
where A is the column of VAR1, B of VAR2, C of VAR3 and D of VAR4.
Just place the formula inside the column E
(check the indices ; the formula above is for the line number 7 (E7))

Excel formula with double quote with C# 
I have not succeed to find the reason why there can be no double quotes
written into an excel formula. However there is a solution to avoid double
quotes:
string formula = "=COUNTIFS({0}!E:E, {1}, {0}!A:A , CONCATENATE(CHAR(62),
CHAR(48)))";

Excel Array formula for sum if combination 
Are you getting a formula error for certain inputs?
If so, I would suggest breaking the formula into smaller and smaller
constituent parts until you are able to successfully isolate the portion
causing the error.

Excel VBA setting cell value to a formula 
Something like....
Sheets("Standalone Non Clustered").Range("G10").Formula =
"=CEILING(Worksheet!$G$9*(1+Worksheet!$G$10+Info!$B$14),5)"
Sheets("Standalone Non Clustered").Range("G10:P10").FillRight

Excel formula to return the value that is not equal to "x" 
If I understand you correctly
=IF(B1=TRUE,A1,"")
Add this formula to cell C1 and drag down.

Turning an excel formula into a VBA function 
Here is a simple solution...
Building_name = ???
Date = ???
Last_Row = Range("A65536").End(xlUp).Row
For i = 1 To Last_Row
if cells(i,1).value = Building_Name Then
if date >= cells(i,4).value Then
if date <= cells(i,5).value Then
first instance = cells(i,6).value
end if
end if
end if
next
you should add a test at the end to avoid the case where there is no first
instance in the table

Excel formula Comparing two arrays 
If I understand right, you want to populate the calendar with the start
dates from xTable with TRUE when found and with FALSE otherwise?
You can use this formula in cell B2 and fill it right and down:
=IF(COUNTIFS($A$13:$A$19,$A2,$B$13:$B$19,B$1*1)=0,FALSE,TRUE)
I'm using B$1*1 just in case you have the dates stored as number in row A1.
Otherwise, if they are stored as date but formatted as dd (or equivalent),
use DAY(B$1) instead.
The formula will count the number of occurrences of a row with the
corresponding name and start date of table xTable using COUNTIFS. If none
are found, it will return 0, which yields to FALSE.

Excel Formula Not Updating Cell 
You have to explicitly trigger a recalculation. See the Recalculation of
Formulas section here about why & how to do it.

Error with Nested Excel IF formula 
2 Issues:
Missing parenthesis in the ISBLANK function. (On second thoughts, this
looks like a copy/paste issue.)
Missing cell number in the LEFT function.
Should be:
=IF(ISBLANK(CG3),"",IF(LEFT(CG3,2)="/m","mcat"&CG3,"icat"&CG3))

How do I convert this Excel formula into VBA code? 
You need to escape your quotes.
ActiveCell.Formula = "=IF(O6=""Hand"",""Manual
Entry"",IF(O6=""JET"",R6,IF(O6=""COKE"",""Red
Bull"",IF(O6=""Freight"",""Logistics"",IF(O6=""TAX"",""Tax"",IF(O6=""TRANSFER
COST"",""Transfer Cost
Transactions"",IFERROR(IF(FIND(""INV#"",R6,1)>=1,MID(R6,FIND(""INV#"",R6,1),10),""""),"""")))))))"
And use .Formula since you're using specific cell names that are not
relative to the currently selected cell.

excel "IF" formula returning "0" (it shouldn't) 
Possible answer:
The "IF" formula will only return the "0" value in these conditions:
1. "Value_if_true" = 0 AND Logical_test = TRUE
2. "Value_if_false" = 0 AND Logical_test = FALSE
3. "Value_if_true" = "0" AND Logical_test = TRUE
4. "Value_if_false" = "0" AND Logical_test = FALSE
5. "Value_if_true" = (NULL) AND Logical_test = TRUE
6. "Value_if_false" = (NULL) AND Logical_test = FALSE
According to your screenshots, you have strings in both "Value_if_true" and
"Value_if_false". So we must check how Excel are evaluating these strings:
In Excel (2010), go into
"Options" > "Advanced" > "Lotus Compatibility Settings for:
[YourSheetName]"
Check if the "Transition formula entry" option is checked. If it is, then
you probably found your problem. You just need

Excel formula only working on first cell 
First, delete everything in the missing groups column (or copy it somewhere
else, just in case).
then enter this formula in C2
=IF(ISNA(MATCH(TRIM([@[All Groups]]),TRIM([Site Collection
Groups]),0)),TRIM([@[All Groups]]),"")
Then press ctrl+Shift+Enter (instead of just enter)
This will trim both the single entry for column A and all of the entries
for column B. It also uses table references for everything (instead of
referencing A2, etc).
