If and then statements.

K

KAD

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.
 
M

Marcelo

=if(b2="X",a2,"")

htt
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"KAD" escreveu:
 
R

Rick Rothstein \(MVP - VB\)

Assuming Row 2 for this example, try this in C2...

=IF(B2="x",A2,"")

This formula can be copied down.

Rick
 
M

Marcelo

thanks for the feedback

glad to help

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"KAD" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0
Format column widths from one table to a separate table on same page 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
sqlite-odbc write conflict 2
Extracting a cell value 2
Having Blank Cells, etc. ? 1
MS Project Center-Autolink column fields 0

Top