Ms excel fomulas

google-- user manual for excel-- and you will find that information in the 900 pages of the pdf version download

Here is the solution for your problem:

http://chandoo.org/wp/2008/10/22/sorting-text-in-excel-using-formulas/

Format cells A1 and B1 to dates.

A1 is the first date
B1 is the 2nd date
C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

use if statement
=IF(AND(OR(A1="clark",A1="skamania",A1="clickitat"),B1="WA"),1,0)
where A1=T2 and B1=U2

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

1. =A1-A2
2. =SUM(A1,-A2)

The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

=SUM(Cell1,Cell2,Cell3)/sold_price
Where Cell1, Cell2 and Cell3 are the cell references for the 1st, 2nd and 3rd loan fields and the sold price is the field reference for the cell that has the value for the sold price in it.

The only thing I see wrong in your formula is a missing colon.

COUNTIF($C$2:$C$999,C2)=1

www.google.com

1. formula