Kashi na canza dabarar a cikin Excel

Ana amfani da dabarar canjin kashi sosai a cikin Excel. Misali, don lissafta kowane wata ko jumillar canji.

Canjin wata-wata

1. Zaɓi tantanin halitta C3 kuma shigar da dabarar da aka nuna a ƙasa.
2. Zaɓi tantanin halitta C3 kuma a yi amfani da tsarin kashi zuwa gare shi.
3. Domin kar a sake maimaita mataki na 1 da na 2 sau goma, zaɓi tantanin halitta C3, danna kan ƙananan kusurwar dama kuma ja shi ƙasa zuwa tantanin halitta С13.
4. Duba idan komai yayi kyau.

Canjin gabaɗaya

1. Hakazalika, zamu iya ƙididdige jimlar canji. A wannan lokacin muna gyara magana zuwa tantanin halitta V2. Hana tantanin halitta D3 kuma shigar da dabarar da aka nuna a ƙasa.
2. Zaɓi tantanin halitta D3 kuma a yi amfani da tsarin kashi zuwa gare shi.
3. Hana tantanin halitta D3, danna kan ƙananan kusurwar dama kuma ja shi ƙasa zuwa tantanin halitta D13.
4. Duba idan komai yayi kyau.

Ƙarin bayani: Lokacin da muka ja (kwafi) dabarar ƙasa, cikakken bayanin ($ B$2) ya kasance baya canzawa, amma bayanin dangi (B3) yana canzawa - B4, B5, B6, da sauransu. Wannan misalin na iya zama da wahala a gare ku a wannan matakin. amma yana nuna wasu abubuwa masu amfani da ƙarfi waɗanda Excel ke da su.