bhaiyon mujhe excel mein ek formula chahiye jis ke zarye percentage nikala jata hai.
jaise agar kisi cheez ki kimat 99hai aur usper discount 65% hai to yeh excel mein kaise nikala jaye
99/65%= is ka formula chahiye.
bhaiyon mujhe excel mein ek formula chahiye jis ke zarye percentage nikala jata hai.
jaise agar kisi cheez ki kimat 99hai aur usper discount 65% hai to yeh excel mein kaise nikala jaye
99/65%= is ka formula chahiye.
Bhai this called average
=average(colum+row:colum+row)
dear =range/range or =range/25%
Kia iss tarha pooch rahay hain bhai?
=Price-Price*percent_discount
Column B main Sale Price enter keejiay
Aor
ager discount (65%) fixed hay her item per (ya her rate per) to yeh formula likhiay
=B2-(B2*0.65)
ya jitni zyada sale ussi munasbat say discount to phir B Colum main price (or Sale) likhiay, C Colume main Discount (sale ki munasibat say, jitnay percent discount dena hay) woh enter keejiay or screen shot main diya gaya formula enter kar deejiay, Target Cell main.
sabhi bhaiyon ka bohot bohot shukriya.
Bookmarks