Is there such a thing as an "if" command in excel?
 

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?

Is there such a thing as an "if" command in excel?
 

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?

Is there such a thing as an "if" command in excel?
 

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?

Is there such a thing as an "if" command in excel?
 

Thank you.

So if say I wanted to do a formula for example so that

If column B10 = 1 the figure from A10 will go into C10
If column B10 = 2 the figure from A10 will go into D10
If column B10 = 3 the figure from A10 will go into E10 etc etc what would
the formula be for that?

Thanks




"Toppers" wrote:

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?

Is there such a thing as an "if" command in excel?
 

That would require VBA coding, not a straight formula.

"paulas27" wrote:

Thank you.

So if say I wanted to do a formula for example so that

If column B10 = 1 the figure from A10 will go into C10
If column B10 = 2 the figure from A10 will go into D10
If column B10 = 3 the figure from A10 will go into E10 etc etc what would
the formula be for that?

Thanks




"Toppers" wrote:

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?

Is there such a thing as an "if" command in excel?
 

Actually, one thing you could do which would not require VBA coding is the
following.

In cell C10: =IF(B10=1,A10,"") -- means "if the value in B10 is 1, THEN
input the value in A10, ELSE, do nothing."
In cell D10: =IF(B10=2,A10,"")
In cell E10: =IF(B10=3,A10,"")

etc.

Dave


"Dave F" wrote:

That would require VBA coding, not a straight formula.

"paulas27" wrote:

Thank you.

So if say I wanted to do a formula for example so that

If column B10 = 1 the figure from A10 will go into C10
If column B10 = 2 the figure from A10 will go into D10
If column B10 = 3 the figure from A10 will go into E10 etc etc what would
the formula be for that?

Thanks




"Toppers" wrote:

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?