Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Excel operate a function based on a true or false result?
Can anyone help me to solve this problem. I have data in two columns and wish
to return a result depending on the contents of the two columns being true. i.e. Column A contains 'Lab', 'Mats' or 'Stock' column B contains a numerical value, what I wish to achieve is if A contains 'Lab' and B contains a specific numerical value then a seperate alpha value will be entered in column C. The specific values can be listed in a seperate table if needs be. I'm not sure if this double function is possible in Excel and would appreciate any help you can give me |
#2
|
|||
|
|||
In cloumn C use this formula:
=IF(AND(A1="Lab",B1=x),"alpha value","") x = specific numerical value "SteveD" wrote: Can anyone help me to solve this problem. I have data in two columns and wish to return a result depending on the contents of the two columns being true. i.e. Column A contains 'Lab', 'Mats' or 'Stock' column B contains a numerical value, what I wish to achieve is if A contains 'Lab' and B contains a specific numerical value then a seperate alpha value will be entered in column C. The specific values can be listed in a seperate table if needs be. I'm not sure if this double function is possible in Excel and would appreciate any help you can give me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Excel function problems | Excel Worksheet Functions | |||
Will the Excel WEEKNUM function become ISO 8601 compliant? | Excel Worksheet Functions | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |