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?
|