Ōrau huringa tātai i Excel

Ko te tauira huringa ōrau he tino whakamahia ki Excel. Hei tauira, ki te tatau ia marama, huringa katoa ranei.

Te huringa o ia marama

  1. Tīpako pūtau C3 ka tomo i te tauira e whakaaturia ana i raro nei.
  2. Tīpako pūtau C3 ka hoatu te whakatakotoranga ōrau ki reira.Ōrau huringa tātai i Excel
  3. Kia kore ai e tukurua te taahiraa tuatahi me te taahiraa tuarua kia tekau nga wa, tohua te pūtau C3, paatohia tona kokonga matau o raro ka toia ki raro ki te pūtau Tuhinga o mua.Ōrau huringa tātai i Excel
  4. Tirohia mehemea i pai nga mea katoa.Ōrau huringa tātai i Excel

Huringa whanui

  1. Waihoki, ka taea e tatou te tatau i te huringa katoa. I tenei wa ka whakatikahia e matou te tohutoro ki te pūtau V2. Miramirahia he pūtau D3 ka tomo i te tauira e whakaaturia ana i raro nei.Ōrau huringa tātai i Excel
  2. Tīpako pūtau D3 ka hoatu te whakatakotoranga ōrau ki reira.
  3. Miramirahia he pūtau D3, paatohia tona kokonga matau o raro ka toia ki raro ki te pūtau D13.
  4. Tirohia mehemea i pai nga mea katoa.Ōrau huringa tātai i Excel

Whakamārama: Ina toia (kapehia) te tauira ki raro, ka noho tonu te tohutoro tino ($B$2) kaore e rereke, engari ka huri te tohutoro whanaunga (B3) - B4, B5, B6, me etahi atu. He tino uaua tenei tauira mo koe i tenei wa, engari e whakaatu ana i etahi o nga ahuatanga whaihua me te kaha kei a Excel.

Waiho i te Reply