Re: HOW TO CONVERT A1=1 TO C2=SECONDS ,, EXCEL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: BenjieLop (BenjieLop.1ehe9e_at_excelforum-nospam.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 09:49:43 -0500

Mike,

You are more than welcome ... I am just glad that I can help as I have
had received a lot of help from here as well.

Don't sweat it because you are, in your words, "a real novice excel
user." Everyone here, even the experts, were novices at one time or
another.

Mike Wrote:
> Thank you thank you.. That was great .. As you can tell I'm a real
> novice
> excel user.
> Actually dummy excel user... So really thanks again.. I spent three
> hours
> trying to work that out ...
>
> "BenjieLop" wrote:
>
> >
> > Just enter this formula in whatever cell you choose then
> >
> > =if(A1="","",20*A1)
> >
> >
> > Mike Wrote:
> > > Thank you so much . But I'm afraid that I probably didn't explain
> that
> > > correctly.
> > > I was trying to enter a formula so as to change the ( 1 ) to 20
> > > seconds.
> > > So if I enter ( 2 ) in A1 my result in C2 or B2 would be ( 40 )..
> > > Again thank you
> > >
> > > "BenjieLop" wrote:
> > >
> > > >
> > > > Enter in cell C2
> > > >
> > > > =if(A1=1,"Seconds","")
> > > >
> > > >
> > > > Could this be what you want?
> > > >
> > > >
> > > > --
> > > > BenjieLop
> > > >
> > > >
> > > >
> > >
> ------------------------------------------------------------------------
> > > > BenjieLop's Profile:
> > > http://www.excelforum.com/member.php?action=getinfo&userid=11019
> > > > View this thread:
> > > http://www.excelforum.com/showthread.php?threadid=270924
> > > >
> > > >
> >
> >
> > --
> > BenjieLop
> >
> >
> >
> ------------------------------------------------------------------------
> > BenjieLop's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=11019
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=270924
> >
> > 

-- 
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread: http://www.excelforum.com/showthread.php?threadid=270924

Relevant Pages

  • Re: HOW TO CONVERT A1=1 TO C2=SECONDS ,, EXCEL
    ... > Don't sweat it because you are, in your words, "a real novice excel ... > Mike Wrote: ... >> excel user. ...
    (microsoft.public.excel.misc)
  • Macro help
    ... As I am quite a novice at excel. ... Mike ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Windows XP SB 2
    ... Taskbar Repair Tool Plus! ... "Mike is a novice! ... I thought that for now I could just install the above operating system ...
    (microsoft.public.windowsxp.general)
  • Re: Questions about 3 in one machines?
    ... It helps a novice like myself. ... Mike B. ... On Nov 24, 4:30 pm, F. George McDuffee <gmcduf...@mcduffee- ... car too. ...
    (rec.crafts.metalworking)
  • Macro help
    ... As I am quite a novice at excel. ... Mike ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)