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: |

The SSE was the first modern stock exchange to open in China, with trading commencing in 1990. It has now grown to become the largest stock exchange in Asia and the third-largest in the world by market capitalization, which stood at RMB 50.6 trillion (US$7.8 trillion) as of September 2021. Stocks (both A-shares and B-shares), bonds, funds, and derivatives are traded on the exchange. The SEE has two trading boards, the Main Board and the Science and Technology Innovation Board, the latter more commonly known as the STAR Market. The Main Board mainly hosts large, well-established Chinese companies and lists both A-shares and B-shares.

Traders also expressed uncertainty about the situation with China Evergrande, as the indebted property company has not provided clarification about a key interest payment.In economic news, the Commerce Department reported an unexpected increase in U.S. new home sales in August.Crude oil prices climbed Friday and front-month WTI oil futures contracts saw gains for a fifth straight week amid tighter supplies. West Texas Intermediate Crude oil futures for November rose $0.68 or 0.9 percent at 73.98 a barrel. WTI Crude futures gained 2.8 percent for the week.

Excel Hacks from tw


Telegram Excel Hacks
FROM USA