answersLogoWhite

0

There are thousands of complex formulas you can create in Excel. Here are a few examples:

=CHOOSE(WEEKDAY(F$4 & " " & $F$1),"S","M","T","W","T","F","S")

{=SUM(($A$5:$A$154=$E$169)*($E12:$E161<>"")*1)}

=OFFSET(Data!$D$15,0,0,COUNTA(Data!$D:$D),1)

=IF(SUM(AUG!$O$7:$S$7)=0,"",SUM(AUG!$O$7:$S$7))

=REPLACE(B3,FIND("code",B3),3,"upc")

=SUBSTITUTE(TRIM(A2 & " "& B2 & " " & C2 & " " & IF(LEN(B2)=1," ", IF(LEN(D2)=0,"",IF(B2=D2," ","("&D2&")"))) & " " & E2), " ", " ")

=YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1),

DAY(A2)<DAY(A1))),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AND(MONTH(A2)

<=MONTH(A1),DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<MONTH(A1),DAY(A2)

>=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A2)<DAY(A1)),-1)))&" months,

"&A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&" days"

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is in an expression?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


What is an expression in excel?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


Does an Excel complex formula use more than one arithmetic operation?

A complex formula in Excel could have many arithmetic operators in it. There are many things that make a formula complex, so a formula with just one arithmetic operator or even no arithmentic operators could be complex too, depending on what it does.


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.


What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.


Is equals A1 equals A14 a complex formula in excel?

It is not very complex. It is a logical function. It would be comparing the contents of A1 and A14. If they are the same it will give the result TRUE. If they are not the same it will give the result FALSE.


What is a rule in excel?

it is a formula


Formula for the calculation of gratuity?

Excel Arrears calculation Only Formula Download Excel Arrears calculation Only Formula Download but free download Excel Arrears calculation Only Formula Download but free download not option


Where Excel displays the formula that is in a cell IS WHAT?

The formula bar.


What is the symbol that tells excel that you are about to begin a formula?

the asterisk is used for what function when building a formula in excel