if formula

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » If Formula

If Formula

resolvedResolved · Medium Priority · Version 2003

Sarah has attended:
Excel Advanced course

If Formula

I've havning a problem with the following If formula Validation range :
If cell = 2, Sum cell * cell
After today's course, I may be able to resolve the formula myself, but it would help to receive clarification on where my error is.

RE: If Formula

Hi Sarah

Sorry for the delay in answering this question.

The IF function allows a calculation to be created in a cell if a condition occurs

With the little data you gave me I


 

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.09 secs.