Telegram Group & Telegram Channel
Ячейкаларни солиштириш.

Excel
да ячейкаларни солиштириш учун:
=Биринчи ячейка = Иккинчи ячейка
формуласидан фойдаланишингиз мумкин.

Лекин сизга матн регистри аҳамиятга эга бўлса:
=СОВПАД(Биринчи ячейка ; Иккинчи ячейка)
формуласидан фойдалансангиз тўғри бўлади.

ИСТИНА ва ЛОЖЬ натижасини бошқа кўринишга олиб келмоқчи бўлсангиз, формулангизга ЕСЛИ (АГАР) логикасини қўшимча қиласиз.

Яъни:
=ЕСЛИ(A3=B3;"Тўғри";"Нотўғри")
=ЕСЛИ(СОВПАД(A3;B3); "Тўппа тўғри" ; "Нотўғри шекилли")


Excel Hacks видеокурси | 1C видеокурси
👍22👏4🔥3



tg-me.com/excel_hacks/550
Create:
Last Update:

Ячейкаларни солиштириш.

Excel
да ячейкаларни солиштириш учун:
=Биринчи ячейка = Иккинчи ячейка
формуласидан фойдаланишингиз мумкин.

Лекин сизга матн регистри аҳамиятга эга бўлса:
=СОВПАД(Биринчи ячейка ; Иккинчи ячейка)
формуласидан фойдалансангиз тўғри бўлади.

ИСТИНА ва ЛОЖЬ натижасини бошқа кўринишга олиб келмоқчи бўлсангиз, формулангизга ЕСЛИ (АГАР) логикасини қўшимча қиласиз.

Яъни:
=ЕСЛИ(A3=B3;"Тўғри";"Нотўғри")
=ЕСЛИ(СОВПАД(A3;B3); "Тўппа тўғри" ; "Нотўғри шекилли")


Excel Hacks видеокурси | 1C видеокурси

BY Excel Hacks




Share with your friend now:
tg-me.com/excel_hacks/550

View MORE
Open in Telegram


Excel Hacks Telegram | DID YOU KNOW?

Date: |

Unlimited members in Telegram group now

Telegram has made it easier for its users to communicate, as it has introduced a feature that allows more than 200,000 users in a group chat. However, if the users in a group chat move past 200,000, it changes into "Broadcast Group", but the feature comes with a restriction. Groups with close to 200k members can be converted to a Broadcast Group that allows unlimited members. Only admins can post in Broadcast Groups, but everyone can read along and participate in group Voice Chats," Telegram added.

Telegram announces Search Filters

With the help of the Search Filters option, users can now filter search results by type. They can do that by using the new tabs: Media, Links, Files and others. Searches can be done based on the particular time period like by typing in the date or even “Yesterday”. If users type in the name of a person, group, channel or bot, an extra filter will be applied to the searches.

Excel Hacks from pl


Telegram Excel Hacks
FROM USA