using If formula with condition

May 2, 2011 at 06:39:04
Specs: Windows XP
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 ..


See More: using If formula with condition

Report •

#1
May 2, 2011 at 12:01:25
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 than the 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.


Report •
Related Solutions


Ask Question