i have got 10 rows of installment due amount figure, next two column is of paid amount & balance due. What i wana do is """ if(the paid amount is greater than installment due than it should be shown as , paid) "" for example..

installment due is of 650000/- & paid amount is 700000/- , balance due is (-50000)..

now since the paid amount is greater than installment due than it should show as PAID..help me ..

I can't tell where you want your results, nor can I tell what you want the result to be if the paid amount is less thanthe installment due.Please provide some examples using columns so we can better understand what you are looking for.

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History