Yes ...

=IF(condition, result if True, result if False)

e.g.

=IF(A1B1,"ABC","DEF")

If A1B1 result is "ABC" otherwise it is "DEF"

ABC/DEF could be replaced by cell references/formulae

HTH

"paulas27" wrote:

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?