fazal khaliq

[fazal_khaliq]

مجھے اس سوال کا جواب درکار ہےشیٹ اٹیچ کررہا ہوں

[Derwaish]

thread move to aae

[syar]

مجھے اس سوال کا جواب درکار ہےشیٹ اٹیچ کررہا ہوں

Need to understand two things

1.Pieces*C10 standerd weight+1%
is sa kya murad ha? which one is correct ( as per your sheet)
((C13*C10)+(C13*C10)*1%) jo k 1562.2579 banta ha
or
(C13*C10)+1%) jo k 1546.8 banta ha. konse calculation drust ha.

2. Less aur excees aap kis sa compare karain ge.Aap ka formula ha

Pieces*C10 standerd weight+1%-D13 Raning weight(less less main or excess excess main

yani total weight agar running weight sa less ho tu less count karain ge. ya aap is ko PO ki Quantity jo ka 52500 kg ha sa compare karain ge. Please explain.

Agar ho sake tu aap manual calculate kar k less aur excess m lekh dain. Formula m forum p koi bhe help kar daige.

regards

[fazal_khaliq]

total weight agar running weight sa less ho tu less count karain ge

[mujtaba_jdw]

bhai zara wazahat karien ap karna kia chahty hain ??

[fazal_khaliq]

raninig weight se - kerna he agar less atta he to less main or agar excess atta he to excess main

[fazal_khaliq]

stranded weight party ke requirement he

[fazal_khaliq]

koi tu jawab du

[fazal_khaliq]

mera adha jawab hal ho gya main excel main agr bar bar sawal karon tu koi problames tu nahain hogi mojhay it ke dunya buhat achee lgee umeed he main es se bohat mustafeed honga

[fazal_khaliq]

mera adha sawal hal hogaya sukriya

[fazal_khaliq]

adha jawab mil gaya

[syar]

adha jawab mil gaya

May be may theek samjha hon. Try
H13
=IF(((C13*$C$10)+(C13*$C$10)*1%)<D13,((C13*$C$10)+ (C13*$C$10)*1%),"")

I13
=IF(((C13*$C$10)+(C13*$C$10)*1%)>D13,((C13*$C$10)+ (C13*$C$10)*1%),"")

and copy down. please feed back
regards