Excel formula chahiye

[alim khan]

freinds excel mein aap logon ki help chahiye. mujhe do row ke bich mein difrence nikalna hai. agar eik row mein 1000 hai aur dosri mein 900 hai to jo 900 hai woh minus (-)sign. mein aana chahiye aur agar 1100 hai to plus(+)sign. mein aana chahiye koi formula batao.

row A --------------- row B
1000.........................-100
.................................+100



........................NOKIA...............SAM SUNG...........................HTC
..........................1000...................9 00...............................1200

DIFRENCE............1000................-100..................................+200

[joejeejay]

1

2

[*ESHA*]

I think =add(Select Cells) Enter

[smart_bilal123]

Nice Info Neelam

[syar]

salam::

aap simple add/subtract kar sakte hain jaise ke aap ko oper bataya gaya ha.

Leekan agar aap ye chahte hain k jo number positive hon unke saath + ka sign aur jo negative hon unke saath - ka sign aae tu aap ko is ke leye custom formatting ke zaroorat ho ge. Formula se mere elam me nahee ka + ya - ka sign aa sake. agar aap ka masla oper bataye gae howe tareeqe se hal hota ha tu theek. Otherwise reply karain m aap ko custom formatting bata don ga.

[alim khan]

freinds mera masla hal nahi huwa.custom formatting ke bare mein bata do.

[syar]

salam::

Well pehle ye file check karain ke aap ka matlooba result sahee ha.

[syar]

salam::

agar mere sheet ke mutabiq aap ka result sahee ha tu

in b2 and copy across

=B2-$A$2

aur apne range select karain jin me ye formula apply keya ho say b2:h2 ya aap ke jo original range ho.
phir format ---> cell---> custom, m ja kar ye formatting paste kar dain aap ka masla hal ho jae ga.

+#,000;-#,000;0

regards and reply back

[alim khan]

salam::

aap simple add/subtract kar sakte hain jaise ke aap ko oper bataya gaya ha.

Leekan agar aap ye chahte hain k jo number positive hon unke saath + ka sign aur jo negative hon unke saath - ka sign aae tu aap ko is ke leye custom formatting ke zaroorat ho ge. Formula se mere elam me nahee ka + ya - ka sign aa sake. agar aap ka masla oper bataye gae howe tareeqe se hal hota ha tu theek. Otherwise reply karain m aap ko custom formatting bata don ga.

salam::

Well pehle ye file check karain ke aap ka matlooba result sahee ha.

BHAI NOT WORKING + SING NAHI AA RAHI HAI SYAR BHAI AAP KI FILE CHECK KAREN JAHAN 900 WAHAN PER 1200 KARNE PER + KI SIGN. NAHI AA RAHI HAI.

[sayhellotoit]

Wassalam,
Check the attached file. No custom formatting needed, it is just the formula.

[syar]

Please check attached files

[syar]

Salam sayhellotoit!

Nice approach.