Thread: Formulas
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MFS MFS is offline
external usenet poster
 
Posts: 36
Default Formulas

Sorry No2
You can try this, if C1 bigger than 1,000 copy D1, if not put 0
=IF(C21000;D2;0)

--
MFS22


"MFS" كتب:

You can try this, if D1 bigger then 1,000 copy C1, if not put 0
=IF(D21000;C2;0)

--
MFS22


"Formula1" كتب:

Is there a formula to copy data from ex. column D, based on the info in Col C?