1. Welcome to PHCorner Forums. Take a moment to Sign up and gain unlimited access and extra privileges that guests are not entitled to, such as:

    All that and more! Registration is quick, simple and absolutely free. Join our community today!

help excel expert

Discussion in 'Coding, Programming' started by Jetpogi, Jun 24, 2016.

  1. Ptp. Admin palipat nalang po kung Mali ..salamat po

    Sino po ang magaling gumawa ng excel formula dito.sana po matulungan inyo ako.
    Ito po sitwasyon.
    Text1 + text1 = text1
    text1 + text2 = text2
    text1 + text 3 = text3
    text2 + text1= text1
    text2 + text2 = text2
    text2 + text3 = text3
     
  2. Hndi ko din po Alan ung concatenate mam.. Bka po matulunagn niyo ako.

    If cell1 and cell2 is equal text1 and text2
     
  3. hindi ko maintindihan ang problem. pero kailangan mo yata ng conditional statement : type lang ng IF sa cell tapos may lalabas dyan na tooltip e.g : if( condition, true , false )
    sample statement. cell1 is at A1 , cell2 at B1 and cell3 is at C1. if cell1 equals cell2 then cell3 equals cell1 otherwise cell2.
    type the code at C1: if( A1=B1 , A1,B1)
    or if you mean idudugtong yong text or called concatenation e.g "A"+"KO" = AKO. type i think CONCATENATE ,may lalabas naman na tooltip . basahin lang ang syntax
     
  4. TS lagyan mo ng value para masmalinaw. At anu po ba ang end result na gusto mo po? Same Row po ba ito? yung "=" value po ba may fixed value?
     
  5. ito pagkakaintindi ko sa problem. just in case di mo pa din nahahanap yung solution.

    assuming cell1 is A1 and cell2 is B1, paste the formula in cell C1 then drag down

    =SUBSTITUTE(B1," ","")
     
Tags / Keywords: