
مشاركة: كيفية حساب الدمغة العادية باستمارة المرتبات الحكومية بالإكسيل
=ceiling(if(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7>10000,80+((o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7-10000-50)*3/1000),if(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7>5000,(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7-50)*8/1000,if(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7>1000,(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7-50)*7.5/1000,if(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7>500,(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7-50)*7/1000,if(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7>250,(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7-50)*6.5/1000,if(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7>50,(o7+sum(bi7:bz7)-co7-cr7-cu7-cw7-cx7-da7-cv7-cp7-cq7-50)*6/1000,0)))))),0.05)