If the cell have numbers, then do some calculation

[Binpj]

Hi,

No	Date	Amount	Interest	Principal amount	Loan Balance
EMI 1	13-Nov	1230	343.75	886.25	24113.75
EMI 2			=K5*16.5%/12	=H6-I6	=K5-J6
EMI 3			336.12	-336.12	24781.44
EMI 4			340.74	-340.74	25122.18
EMI 5			345.43	-345.43	25467.61
EMI 6			350.18	-350.18	25817.79

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

I have applied some simple calculations againist EMI 2. I need that calculation only if if enter numbers in the amount column. Is there any possibility

 

[AlanY]

try

=if(isblank(K5),"",..calculation here..)

 

[Binpj]

Thank you. Its working

 

[AlanY]

you're welcome