Page 140 - Bangladesh_classwiz_BOOK2018_rev_Neat

Øviv ¸Y Ki‡Z n‡e Ges djvdj¸‡jv Kjv‡g msiwÿZ Ki‡Z n‡e| wb‡Pi g‡Zv K‡i GKwU GKK wb‡`©kbv
Fill Value e¨envi K‡i GwU Kiv hvq| 1 N‡i Kvm©i _vKv Ae¯’vq OPTN menu ‡_‡K 2 †P‡c Fill

value wb‡`©kbvq †h‡Z nq| Fill Value wb‡`©kbvi `yBwU Ask| cÖ_gwU n‡jv Value ‡hLv‡b Formula wjL‡Z
n‡e I wØZxqwU n‡jv Range A_©vr GK¸”Q N‡ii Rb¨ e¨ewa hvi Dc‡i Formula -wU cÖ‡qvM Ki‡Z n‡e|

cÖ_‡g Formula wU UvBc K‡i = evUb Pvc‡Z n‡e| Value wb‡`©kbvi dg©~jvwU‡Z †h Ni¸‡jvi (A1 ‡_‡K
A6) Rb¨ Formula cÖ‡qvM Ki‡Z n‡e Zvi cÖ_g NiwU ( 1) e¨envi Ki‡Z nq| Kvm©i (!$) Ges oKx
e¨envi K‡i Range m¤úv`bv Ki‡Z nq| G‡ÿ‡Î Range n‡e B1: B6| Range cÖ‡ek Kiv‡bvi ci `yBevi
= Pvc‡j Formula wU A1 ‡_‡K A6 cÖwZwU N‡ii gvb¸‡jvi Dci cÖ‡qvM n‡e Ges B1 †_‡K B6 Ni¸‡jv‡Z

djvdj cÖ`wk©Z n‡e|

T1 e¨envi K‡i Av‡iK ai‡bi Fill wb‡`©kbv (Fill Formula) e¨envi K‡i cÖwZwU N‡i dg~©jv Ges gvb
DfqB cÖ‡ek Kiv‡bv hvq| G‡ÿ‡Î C1 ‡_‡K C6 N‡i wb‡Pi w¯Œ‡bi g‡Zv B Kjv‡gi gvb¸‡jvi Abyiƒc gvb
msiwÿZ n‡e| Fill Formula wb‡`©kbvi cÖ_g Ask A_©vr Formula line G c~‡e© †_‡KB Ô=Õ wPý †`qv Av‡Q|

hw`I C Kjv‡gi gvb¸‡jvi Ges B Kjv‡gi gvb¸‡jv `„k¨Z GK, wKš‘ Kvm©i C Kjv‡gi †h‡Kv‡bv N‡i wb‡q †M‡j

K¨vjKz‡jU‡ii w¯Œ‡bi wb‡P Formula cÖ`wk©Z n‡e| K¨vjKz‡jU‡ii Kvm©iwU‡K C Kjv‡gi Ni¸‡jv‡Z Avjv`v
Avjv`v fv‡e wb‡j †`Lv hv‡e †h, cÖwZwU N‡i Avjv`v Avjv`v Formula cÖ`wk©Z n‡”Q| GB Formula ¸‡jv mswkøó
Ni¸‡jvi Rb¨ MÖnY‡hvM¨| ‡h‡nZz C Kjv‡g Formula Ges B Kjv‡g gvb e¨envi Kiv n‡q‡Q, myZivs A Kjv‡gi
‡Kv‡bv gv‡bi cwieZ©‡bi Rb¨ B Kjv‡gi gvb¸‡jv AcwiewZ©Z _vK‡e| wKš‘ A Kjv‡gi †h‡Kv‡bv N‡ii bZzb gv‡bi
Rb¨ C Kjv‡g msMwZc~Y© cwieZ©b n‡e, hvi KviY c~‡e© Av‡jvPbv Kiv n‡q‡Q| wb‡Pi w¯Œ‡b A Kjv‡gi gvb¸‡jv

cwieZ©b K‡i †`Lv‡bv n‡jv|

jÿYxq †h, C Kjv‡gi cÖwZwU N‡i Avjv`v Avjv`v fv‡e Formula cÖ‡ek Kiv‡bv hvq wKš‘ Fill Formula wb‡`©kbv
e¨envi Kiv myweavRbK|

135