View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_747_] Rick Rothstein \(MVP - VB\)[_747_] is offline
external usenet poster
 
Posts: 1
Default 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