Excel round formula
Niche diye gaye formula se aap Excel mein amounts ko 50 paise ke hisaab se round kar sakte hain:\n\n=ROUND(A1*2,0)/2\n\nIs example mein, maan lijiye ki amount cell A1 mein hai. Aapka amount 50 paise ke niche hoga toh yeh usse 0 par round kar dega, aur agar amount 50 paise se upar hai toh yeh usse 1 par round kar dega.\n\nAgar aapko sirf 0 ya 1 ka result chahiye, jaise pehle example mein bataya gaya hai, toh IF aur ROUND function ka istemal kariye:\n\n=IF(ROUND(A1*2,0)/2=A1, 0, 1)\n\nYeh formula 50 paise ya usse below amounts ke liye 0 dega, aur 50 paise se upar wale amounts ke liye 1 dega.