Naombeni mnisaidie formula ya excel

[R-K-O]

Naombeni mnisaidie formula ya kurahisisha kupata haya majibu kwenye excel.

Kila Box lina chupa 3, chupa 1 ni 0.1, chupa 2 ni 0.2, chupa 3 ni 0.3 sawa na box.

1 ni box moja, 1.1 ni box 1 na unit 1, 2.2 ni box 2 na unit 2, n.k.

Box zikiwa 10 zikitoka 4 jibu liwe 6
Box zikiwa 8 zikitoka 3.3 jibu liwe 4
Box zikiwa 7 zikitoka 6.2 jibu liwe 0.1
Box zikiwa 6 zikitoka 5.1 jibu liwe 0.2
Box zikiwa 5 zikitoka 4 jibu liwe 1
Box zikiwa 4 zikitoka 2.1 jibu liwe 1.2

 

[Andazi]

Simple andika namba ya cell boks zilizipo kisha - boks zilizotoka

Itatoa jibu safi kbs

 

[Mr Pixel3a]

Naombeni formula ya kupata majibu haya kwenye unjano

View attachment 2692030

Izo marks vijana watatoboa kweli?

 

[Andazi]

Simple andika namba ya cell boks zilizipo kisha - boks zilizotoka

Itatoa jibu safi kbs

Usisahau formula inaanza na =

 

[UNSPECIFIED]

Simple andika namba ya cell boks zilizipo kisha - boks zilizotoka

Itatoa jibu safi kbs

=A3-B3 ,kamatia hiyo cell kwa chini scroll kwenda chini utapata majibu yote.

 

[Andazi]

=A3-B3 ,kamatia hiyo cell kwa chini scroll kwenda chini utapata majibu yote.

R-K-O Nilikuwa namaanisha hivi

 

[R-K-O]

=A3-B3 ,kamatia hiyo cell kwa chini scroll kwenda chini utapata majibu yote.

Naomba usome maelezo niliyoyaweka kwenye post ya kwanza

Sio kutoa tu kawaida, nahitaji formula izingatie kila box lina unit 3.

Soma vizuri post ya kwanza

 

[R-K-O]

R-K-O Nilikuwa namaanisha hivi

Naomba usome maelezo niliyoyaweka kwenye post ya kwanza

Sio kutoa tu kawaida, nahitaji formula izingatie kila box lina unit 3.

Soma vizuri post ya kwanza

 

[Andazi]

Naomba usome maelezo niliyoyaweka kwenye post ya kwanza

Sio kutoa tu kawaida, nahitaji formula izingatie kila box lina unit 3.

Soma vizuri post ya kwanza

Rekebisha picha boks zilizobaki ziko mara mbilimbili

 

[R-K-O]

Rekebisha picha boks zilizobaki ziko mara mbilimbili

done

 

[Poor Brain]

Wanajibu tu ila bado hawajakupa clear jibu.. sasa naomba nikusaidie

 

[R-K-O]

Wanajibu tu ila bado hawajakupa clear jibu.. sasa naomba nikusaidie

karibu sana

 

[UNSPECIFIED]

Naomba usome maelezo niliyoyaweka kwenye post ya kwanza

Sio kutoa tu kawaida, nahitaji formula izingatie kila box lina unit 3.

Soma vizuri post ya kwanza

Wewe nae msumbufu sasa si uweke bracket uzidishe mara tatu

 

[R-K-O]

Wewe nae msumbufu sasa si uweke bracket uzidishe mara tatu

nisaidie hio formula niende kuijaribu

 

[Poor Brain]

=if (C3<0.1,A3-B3,0.1)

 

[Kaliro X]

Use ChatGPT

Sent from my M2004J19C using JamiiForums mobile app

 

[R-K-O]

=if (C3<0.1,A3-B3,0.1)

ngoma imekataa

 

[R-K-O]

msaada tafadhali

 

[Poor Brain]

ngoma imekataa

Ongeza condition za kutosha an

 

[Andazi]

Hii hesabu lazima kwanza uwe umeitengeneza chini kabla ya kuweka formula mf.
X zipo 10
Ila X moja ni = Y
Ikiwa Y nisawasawa na 2
X kutoa toa 7
Jibu 13