Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel |