microsoft excel training in london - formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training in london - Formulas

microsoft excel training in london - Formulas

resolvedResolved · Low Priority · Version Standard

Michael has attended:
Excel Advanced course

Formulas

what formula would you put in if you wanted to check if two different cells of data was the same

RE: Formulas

Michael

Try using the DELTA (for numbers) or EXACT (for text strings).

DELTA returns a 0 (No) or 1 (YES) value. You could tack an IF statement into the formula to make it reply YES or NO if you wanted to.

Richard


 

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips


Server loaded in 0.08 secs.