Yes.

The format is:
=IF(criteria, result if true, result if false)

Type in =IF and hit Ctrl+A for help.

Hope this helps.
Andy.

"paulas27" wrote in message
...
In DOS programmes there is an "if" command,which puts figures in a
particular
column depending on the number you put in the "if" column. is there any
way
that i can do this in an excel spreadsheet?