ExcelBanter - If and then statements.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If and then statements. (https://www.excelbanter.com/excel-worksheet-functions/192472-if-then-statements.html)

KAD

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

Marcelo

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

Rick Rothstein \(MVP - VB\)[_747_]

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

KAD

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

Marcelo

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

All times are GMT +1. The time now is 05:02 PM.