Take the 2-minute tour ×
=IF(ISBLANK(S3);"";CONCATENATE(" UPDATE kkr_urunkredi ku
   SET ";IF(ISBLANK($A3);"";CONCATENATE(" ku.yatirimsuresi =''";$A3;"''"));"
       ku.kredikonu_kd  =''";$B3;"'',
       ku.kademeli_drm  ='";IF(S$2 <> $AJ2;H;E);"'
 WHERE ku.kkr_urun_kd =";S3;""))

There is a mistake here with the conditional IF(S$2 <> $AJ2;H;E). Does anyone have a solution?

share|improve this question

1 Answer 1

Apparently changing IF(S$2 <> $AJ2;H;E) to IF(S$2 <> $AJ2;"H";"E") fixed the issue.

share|improve this answer
Don't forget to mark your answer as the solution @blgnklc. It helps the community –  evan.bovie May 21 '12 at 20:01
@emb1995: An answer posted by the question author cannot be accepted until 48 hours after the question was asked. –  DragonLord May 21 '12 at 21:05

Your Answer


