ADD SYMBOL IN FORMULA

SYMBOLS

Dosto aaj ki post me hum aapko batayenge ki excel formula ya command me symbol ko kaise add karte hai, yeh symbol aap insert function ke under symbol ke tab se le sakte hai aur apni command ke hisab se chun kar set kar sakte hai, symbol se table ko ek alag look milta hai aur yeh dekhne me bhi accha lagta hai. to chaliye dosto step by step dekhte hai ki kaise symbol add karte hai.

Step 1

Sabse pehle hum ek table banayege aur table me student name, aur unke marks ko key karengei aur iske sath hi unke marks ke according unka result ki field bhi add karte hai. Issi result ki field me formula me symbol ko add karna hai.

Humare formula ke according jiss student ke number 100 se kam honge uske age [cross] ka symbol hoga aur jiske number 100 se jyada honge uske aage [right] ka symbol hoga.

Step 2

Iske baad insert tab me symbol ke option ko open karke jo symbols aapko chahiye unko apni table wali sheet me kisi bhi cells me paste kar dijiye.

Step 3

Ab aapko result ki field me yeh formula lagana hai, [=IF(B2>100,”yaha right symbol pest”,”yaha cross ka symbol pest”)].

Step 4

Iske baad result ki field me aapko symbol iss tarah se najar aayenge ki 100 mark se kam wale ka result cross & jyada ka result right sign hoga.

Dosto ye to tha formula me symbols add karne ka tarika, aaiye dekhte hai ki symbol wise color ko kaise set karte hai, ye aap apne according customize kar sakte hai, jaise ki hum right ke symbol ko kuch alag color dekhiye kaise.

Step 1

Sabse pehle formula vali field (result) ko select karenge.

Step 2

Iske baad Conditional formating me new rules par click karenge aur “Format only cells that contain” ko select karenge. ab image ke according field ko select kar le aur symbol bhi paste kar dijiye.

Step 3

Ab format button par click karne se color choose karne ka option khulega apne according color set kar sakte hai jaise maine yellow color set kiya hai jo ki aapko rectangle ke under show karega. image dekhein.

Step 4

Iske baad jaise hi hum OK ki button par click karenge to symbol ke according yellow color ka backgroud show karega. image dekhein.

Dosto ye to hai add symbol aur color symbol ki jankaari hindi me, aapko ye post kaise lagi comment karke bataiye jaroor.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

Your email address will not be published. Required fields are marked *