How to make a macro run only for Non-Missing cells

[Former Member]

Hello Experts,

I have to make a macro run only for the cells which have some values, i.e macro should not perform any calculation using blank cells.

Ex.

I want result as this

Quantity	12	25	125	85	45	99
Price	10			55		12
Total Amount	120			4675		1188

but the simple macro which I wrote gives the result as this, it is considering only the first value combination and then pasting result for whole of the iteration period.

Quantity	12	25	125	85	45	99
Price	10			55		12
Total Amount	120	120	120	120	120	120

How do we make this macro to perform the calculation for the nonmissing cells only.

Thanks.

Harshad M.

[RahulHanda · Accepted solution]

Harshad,

Write this default macro as follows:

New macro

     New step : ( 78 Iterations : W 35.2015; W 07.2017 )

          IF

          New condition

               Row: Key Figure Price ( Frm  W 35.2015 )

               > 0                                                              (use operator / function for this)

          Row: Key Figure Total Amount ( Frm  W 35.2015 ) =

               Row: Key Figure Price ( Frm  W 35.2015 )

               *                                                                 (use operator / function for this)

               Row: Key Figure Quantity ( Frm  W 35.2015 )

          ENDIF

I hope this will resolve your issue. If yes follow else raise your concern.

Regards

Rahul

[Former Member · Accepted solution]

Rahul,

Thanks for solution this way it is working.