Apply Excel Formula According to Group

I have Data Like This

image

I need to apply a Excel Formula as :

=IF(M3=“SD”,((H3+J3)*120%)-I3,(H3+J3)-I3)

Where Ever in the Group Column SD is mentioned the Corresponding value to it in the New Limit Column this formula should get applied

Hi,

  1. Use write cell activity and write the formula (cell mention “N2”)
  2. Use auto fill range activity.

Regards,
Dhanush

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.