| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If and then statements.
I have three columns, one row at a time. Column A has a time in minutes.
Column B has or does not have an x. I want column C to show the time in column A if the x is present in column B otherwise stay empty. Thanks in advance. -- JAKA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and then statements.
=if(b2="X",a2,"")
htt -- regards from Brazil Thanks in advance for your feedback. Marcelo "KAD" escreveu: I have three columns, one row at a time. Column A has a time in minutes. Column B has or does not have an x. I want column C to show the time in column A if the x is present in column B otherwise stay empty. Thanks in advance. -- JAKA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and then statements.
Assuming Row 2 for this example, try this in C2...
=IF(B2="x",A2,"") This formula can be copied down. Rick "KAD" wrote in message ... I have three columns, one row at a time. Column A has a time in minutes. Column B has or does not have an x. I want column C to show the time in column A if the x is present in column B otherwise stay empty. Thanks in advance. -- JAKA |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and then statements.
Wow! Works perfectly, thank you so much. You make it seem easy...It's not.
-- JAKA "Marcelo" wrote: =if(b2="X",a2,"") htt -- regards from Brazil Thanks in advance for your feedback. Marcelo "KAD" escreveu: I have three columns, one row at a time. Column A has a time in minutes. Column B has or does not have an x. I want column C to show the time in column A if the x is present in column B otherwise stay empty. Thanks in advance. -- JAKA |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and then statements.
thanks for the feedback
glad to help -- regards from Brazil Thanks in advance for your feedback. Marcelo "KAD" escreveu: Wow! Works perfectly, thank you so much. You make it seem easy...It's not. -- JAKA "Marcelo" wrote: =if(b2="X",a2,"") htt -- regards from Brazil Thanks in advance for your feedback. Marcelo "KAD" escreveu: I have three columns, one row at a time. Column A has a time in minutes. Column B has or does not have an x. I want column C to show the time in column A if the x is present in column B otherwise stay empty. Thanks in advance. -- JAKA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF & OR Statements | Excel Worksheet Functions | |||
| If Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| if statements, I think?? | Excel Discussion (Misc queries) | |||
| IF Statements | Excel Discussion (Misc queries) | |||
Linear Mode
