If and then statements.

  • Thread starter Thread starter KAD
  • Start date Start date
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.
 
=if(b2="X",a2,"")

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



"KAD" escreveu:
 
Assuming Row 2 for this example, try this in C2...

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

This formula can be copied down.

Rick
 
thanks for the feedback

glad to help

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



"KAD" escreveu:
 
Back
Top