Need Help? Contact the Espiya Helpdesk. CLICK HERE


« previous next »
Pages: [1]   Go Down

Author Topic: Boss paturo sa excell  (Read 5713 times)

lesterbadass

  • Active - Two Stars
  • **
  • Posts: 214
  • Karma 12
Boss paturo sa excell
« on: December 13, 2015, 01:33:19 am »
mga idol gusto ko sana ma view yung laman ng 1 cell sa cell kada type ko...example sa A1 "pogi" tinype ko tapos gusto ko cia makita sa C1 diba itytype ko "=A1" dun sa C1 para lumabas din yung "pogi",eh pano kung gusto kung mag type ako sa A2 "panget" gusto ko din cia makita sa cell "C1" at mapapalitan na yung word na "pogi" na hindi ako ng ttype ng "=A2" sa "C1"..maraming salamat mga ka boso bnana
Logged

ToyCar

  • jack of all trades, master of none ;)
  • Gold Member (Premium)
  • Active - Top Level
  • *
  • Posts: 855
  • Karma 89
Re: Boss paturo sa excell
« Reply #1 on: December 13, 2015, 03:26:41 am »
On C1, try the formula =IF(IF(ISBLANK(B1),A1,IF(ISBLANK(A1),B1))=0,"",IF(ISBLANK(B1),A1,IF(ISBLANK(A1),B1)

however, every line there should only be one entry in either A1 or B1 - cannot have entries in both cell otherwise the formula will throw an error.

Logged
If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it.

lesterbadass

  • Active - Two Stars
  • **
  • Posts: 214
  • Karma 12
Re: Boss paturo sa excell
« Reply #2 on: December 13, 2015, 05:08:50 am »
error idol


bali yung a1 magagaling sa ibang sheet kung saan yung naka input sa a1 lalabas sa b1 sa ibang sheet..tapos pag ng type ulit ako sa a2 na kaparehas ng sheet ng a1 same padin yung lalabas sa b1,yung unang nakalagay sa a1 ay mapapalitan na ng ittype ko sa a2,na sya namang lalabas ulit sa b1..pero yung nasa a1 mismo hindi mapapalitan kung baga record na yun.first entry kunwari a1-pogi..lalabas sa b1 nanasa ibang sheet, tapos ng type ulit ako sa a2 naman,mapapalitan na yung naka input sa b1 ng iinput ko sa a2..kung baga yung laman ngaman ng a2 yung lalabas sa b1..thnx ::fingerpower
Logged

ToyCar

  • jack of all trades, master of none ;)
  • Gold Member (Premium)
  • Active - Top Level
  • *
  • Posts: 855
  • Karma 89
Re: Boss paturo sa excell
« Reply #3 on: December 13, 2015, 06:25:03 am »
kulang kasi un unang formula. kung kinopy paste mo lang sya from my message. check mo un screen shot - bale kulang un syntax. dapat
=IF(IF(ISBLANK(B1),A1,IF(ISBLANK(A1),B1))=0,"",IF(ISBLANK(B1),A1,IF(ISBLANK(A1),B1)))

but then again, you changed your requirement. so iba na naman formula kelangan mo. ndi kasi complete requirement mo sa first post mo.
try this formula then:  =IF(Entry!A2<>"",IF(Entry!B2<>"",Entry!B2,Entry!A2),Entry!B2) - where your file should have 2 sheets, 1 i called as Entry and the other as Answer.

see screenies below:







download sample excel file from:
http://www.mediafire.com/view/qn2bii9wwova9ch/Workbook1.xlsx
Logged
If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it.

lesterbadass

  • Active - Two Stars
  • **
  • Posts: 214
  • Karma 12
Re: Boss paturo sa excell
« Reply #4 on: December 13, 2015, 09:07:41 pm »
idol pwd bang pa change ng format yung picture. hindi ko ma open restricted yung pic mo hindi ko ma open letter x lang yung apperance d2 sa desktop ko naka network kc kami..salamat
Logged

ToyCar

  • jack of all trades, master of none ;)
  • Gold Member (Premium)
  • Active - Top Level
  • *
  • Posts: 855
  • Karma 89
Re: Boss paturo sa excell
« Reply #5 on: December 13, 2015, 11:16:37 pm »
the excel file can be downloaded directly from mediafire - why do you need the pics?
Logged
If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it.

lesterbadass

  • Active - Two Stars
  • **
  • Posts: 214
  • Karma 12
Re: Boss paturo sa excell
« Reply #6 on: December 14, 2015, 02:22:04 am »
Logged

maniac2999

  • Console Gamers
  • Active - Top Level
  • *
  • Posts: 1287
  • Karma 178
Re: Boss paturo sa excell
« Reply #7 on: December 14, 2015, 02:47:28 am »
Logged

lesterbadass

  • Active - Two Stars
  • **
  • Posts: 214
  • Karma 12
Re: Boss paturo sa excell
« Reply #8 on: December 14, 2015, 04:35:33 am »
naka network kc sa admin tong desktop may mga bagay bagay na restricted kaya hindi ko ma open kahit fb nga mga sir hindi ko maopen dito..
Logged

maniac2999

  • Console Gamers
  • Active - Top Level
  • *
  • Posts: 1287
  • Karma 178
Re: Boss paturo sa excell
« Reply #9 on: December 14, 2015, 08:20:46 pm »
access mo outside, most likely kahit san iupload yan di mo maviview.
Logged

gemtak

  • Anime Fans
  • Active - First Star
  • *
  • Posts: 10
  • Karma 4
Re: Boss paturo sa excell
« Reply #10 on: December 15, 2015, 02:48:22 am »
Boss copy mo nalang formula na 'to sa b1 ng Sheet2 mo or kung san mo man gusto palabasin yun sagot galing dun sa A1 at A2 sa Sheet1. ;)
Logged

lesterbadass

  • Active - Two Stars
  • **
  • Posts: 214
  • Karma 12
Re: Boss paturo sa excell
« Reply #11 on: December 15, 2015, 02:52:50 am »
asan po yung formula sir??
Logged

gemtak

  • Anime Fans
  • Active - First Star
  • *
  • Posts: 10
  • Karma 4
Re: Boss paturo sa excell
« Reply #12 on: December 15, 2015, 02:55:01 am »
=IF(Sheet1!A2 <>"", Sheet1!A2,IF(Sheet1!A1 <> "", Sheet1!A1, ""))
Logged

ToyCar

  • jack of all trades, master of none ;)
  • Gold Member (Premium)
  • Active - Top Level
  • *
  • Posts: 855
  • Karma 89
Re: Boss paturo sa excell
« Reply #13 on: December 15, 2015, 03:08:18 am »
can't download, can't read previous postings.. how else can we help?
Logged
If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it.
Pages: [1]   Go Up
« previous next »