The help is pretty definitive. What don't you understand about the help on
IF

if condition then

else


End if


if condition then action else ' <= single line if

if condition then

elseif condition then

elseif condition then

end if

in each case, condition is any expression that eventually resolves to true
or false (or a number; zero is false, anything else is true).

Perhaps you just need a basic tutorial or reference on VBA.

http://support.microsoft.com/support...01/default.asp
Microsoft Excel for Windows -- Visual Basic for Applications 101

http://support.microsoft.com/?id=141691
XL: Visual Basic Example Using If and Case Statements

From David McRitchie's site. The VBA tutorials are after the Excel
tutorials:

http://www.mvps.org/dmcritchie/excel....htm#tutorials



--
Regards,
Tom Ogilvy

"Charles" wrote in message
...
Can anyone tell me how to download detailed information on the use of
Excel "If" function. Even Microsoft technical help don't know what I'm
talking about. I use it to a certain extent, but I am sure there is more to
it than I know. Help with syntax in the formula is the main issue.