Need Help update the column

[negi]

HI
i have a table in access 2007 and i want to update the last two column using with formula.please help...
Formula for Status-=IF(AND(C2>0,OR(A2-C2<=B2)),"Paid",IF(AND(D2>0,OR(A2-D2<=B2)),"Pending",IF(AND(OR(D2>10,C2>10)),"Short Premium","Unpaid")))

Formula for Amount:- =IF(AND(C2>0,OR(A2-C2<=B2)),C2,IF(AND(D2>0,OR(A2-D2<=B2)),D2,0))

Value	T_Limit	Amt1	Amt2	Status	Amount
4094.54	90	4095	4100	Paid	4095
28381.8	90	2500	28382	Pending	28382
5033.59	45	5034	5034	Paid	5034
12205.3	90	1200	100	Short Premium	0
5394.07	90	5394	5394	Paid	5394

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

 

[Joe4]

Can you explain the logic of your formulas? Your OR logic is messed up in your formula.
You only use OR if you two or more different conditions to check. Each condition will be located in the parentheses after the OR separated by a comma. You only have one condition. See this link for more details on using OR: http://www.techonthenet.com/excel/formulas/or.php

Hence,

[COLOR=#333333]OR(A2-D2<=B2)[/COLOR]

doesn't really make sense, as you only have one condition in the parentheses.

I am guessing you may have some confusion on when and how to use AND and OR, so I don't want to try to guess what you are intending to do with your formulas.
So, if you can just explain the logic you are trying to incorporate in plan English, we can help you come up with your formulas.