View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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