Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default projecting sales for month

i know formula but can't get it to work;
I have to take the sales for the day multiply it by the accounting day and
then divide it by total number of days but it keeps giving me an error....new
at this please help
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default projecting sales for month

Shoe the formula, and sample data?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Karen Smith" <Karen wrote in message
...
i know formula but can't get it to work;
I have to take the sales for the day multiply it by the accounting day and
then divide it by total number of days but it keeps giving me an

error....new
at this please help



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 380
Default projecting sales for month

Shoe? I mean show of course.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Bob Phillips" wrote in message
...
Shoe the formula, and sample data?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Karen Smith" <Karen wrote in message
...
i know formula but can't get it to work;
I have to take the sales for the day multiply it by the accounting day

and
then divide it by total number of days but it keeps giving me an

error....new
at this please help





  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 418
Default projecting sales for month

Bob Phillips wrote:
Shoe? I mean show of course.


Ed Sullivan lives! :-)

  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default projecting sales for month

I'll bet not too many people know what you're talking about!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
Bob Phillips wrote:
Shoe? I mean show of course.


Ed Sullivan lives! :-)




  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 152
Default projecting sales for month

Was it a "Really big Shoe?"
Wager Dave knows it too!!!
Lou

"Ragdyer" wrote:

I'll bet not too many people know what you're talking about!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
Bob Phillips wrote:
Shoe? I mean show of course.


Ed Sullivan lives! :-)



  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default projecting sales for month

me included ...


"Ragdyer" wrote in message
...
I'll bet not too many people know what you're talking about!<bg
--
Regards,

RD

--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------

-
wrote in message
oups.com...
Bob Phillips wrote:
Shoe? I mean show of course.


Ed Sullivan lives! :-)




  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default projecting sales for month

Ed Sullivan was a Broadway and gossip newspaper columnist for the N.Y. Daily
News, and hosted the longest running variety TV show in TV history.
That show ran on Sunday nights for more then 20 years (late 40's to late
60's I believe), and was responsible for introducing the Beatles to U.S.
audiences, and giving Elvis Presley his first national exposure.

Anyway, he had some peculiar pronunciations, among them, at the beginning of
every show, he'd say:
"We've got a great shoe for you tonight folks."

My parents bought our first TV set, just so they could watch his show.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
me included ...


"Ragdyer" wrote in message
...
I'll bet not too many people know what you're talking about!<bg
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------
-
wrote in message
oups.com...
Bob Phillips wrote:
Shoe? I mean show of course.

Ed Sullivan lives! :-)





  #9   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default projecting sales for month

Thanks for the info Rick. I was aware of Ed Sullivan and his show, just not
his phrases seeing as I have never seen the show (can't believe I have
missed anything).

I think it is claiming rather a lot to '... responsible for introducing the
Beatles to U.S. audiences ...', they were already well-known (otherwise they
wouldn't have been there), he was just the biggest populist to jump on the
band-wagon.

Bob


"Ragdyer" wrote in message
...
Ed Sullivan was a Broadway and gossip newspaper columnist for the N.Y.

Daily
News, and hosted the longest running variety TV show in TV history.
That show ran on Sunday nights for more then 20 years (late 40's to late
60's I believe), and was responsible for introducing the Beatles to U.S.
audiences, and giving Elvis Presley his first national exposure.

Anyway, he had some peculiar pronunciations, among them, at the beginning

of
every show, he'd say:
"We've got a great shoe for you tonight folks."

My parents bought our first TV set, just so they could watch his show.
--
Regards,

RD

--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------

-


  #10   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default projecting sales for month

"Introducing", as in the context of introducing a well known speaker to a
gathering.

The Beatles' *first* U.S. appearance was on his show.

And yes, those boys from Liverpool *didn't* need his support to bolster
their popularity.
They did very well on their own!<g

This brings me to the question of why you folks lose your accent when you
sing?<vbg

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
Thanks for the info Rick. I was aware of Ed Sullivan and his show, just not
his phrases seeing as I have never seen the show (can't believe I have
missed anything).

I think it is claiming rather a lot to '... responsible for introducing the
Beatles to U.S. audiences ...', they were already well-known (otherwise they
wouldn't have been there), he was just the biggest populist to jump on the
band-wagon.

Bob


"Ragdyer" wrote in message
...
Ed Sullivan was a Broadway and gossip newspaper columnist for the N.Y.

Daily
News, and hosted the longest running variety TV show in TV history.
That show ran on Sunday nights for more then 20 years (late 40's to late
60's I believe), and was responsible for introducing the Beatles to U.S.
audiences, and giving Elvis Presley his first national exposure.

Anyway, he had some peculiar pronunciations, among them, at the beginning

of
every show, he'd say:
"We've got a great shoe for you tonight folks."

My parents bought our first TV set, just so they could watch his show.
--
Regards,

RD

--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------

-





  #11   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default projecting sales for month


"RagDyeR" wrote in message
...

This brings me to the question of why you folks lose your accent when you
sing?<vbg



That's odd, I was going to ask you the same thing. We don't have an accent!


  #12   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default projecting sales for month

"I'm 'enery the 8th, I am. 'Enery the 8th, I am, I am...."

http://www.peternoone.com/lyrics/henry8.html

Peter Noone didn't lose his accent.



RagDyeR wrote:

"Introducing", as in the context of introducing a well known speaker to a
gathering.

The Beatles' *first* U.S. appearance was on his show.

And yes, those boys from Liverpool *didn't* need his support to bolster
their popularity.
They did very well on their own!<g

This brings me to the question of why you folks lose your accent when you
sing?<vbg

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
Thanks for the info Rick. I was aware of Ed Sullivan and his show, just not
his phrases seeing as I have never seen the show (can't believe I have
missed anything).

I think it is claiming rather a lot to '... responsible for introducing the
Beatles to U.S. audiences ...', they were already well-known (otherwise they
wouldn't have been there), he was just the biggest populist to jump on the
band-wagon.

Bob

"Ragdyer" wrote in message
...
Ed Sullivan was a Broadway and gossip newspaper columnist for the N.Y.

Daily
News, and hosted the longest running variety TV show in TV history.
That show ran on Sunday nights for more then 20 years (late 40's to late
60's I believe), and was responsible for introducing the Beatles to U.S.
audiences, and giving Elvis Presley his first national exposure.

Anyway, he had some peculiar pronunciations, among them, at the beginning

of
every show, he'd say:
"We've got a great shoe for you tonight folks."

My parents bought our first TV set, just so they could watch his show.
--
Regards,

RD

--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------

-


--

Dave Peterson
  #13   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default projecting sales for month

No, he put it on. Peter Noone was from Manchester, and he was (badly)
mimicking a Cockney accent. If (God forbid) you want to hear a real Cockney
sing it, then listen to Joe Brown and the Bruvvers. But it's only for the
tourists, we don't really speak like that, most Brits are far more obscure,
I can't understand them .



"Dave Peterson" wrote in message
...
"I'm 'enery the 8th, I am. 'Enery the 8th, I am, I am...."

http://www.peternoone.com/lyrics/henry8.html

Peter Noone didn't lose his accent.



  #14   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default projecting sales for month

By George, I think you've got it!

Where does that rain fall?

Bob Phillips wrote:

No, he put it on. Peter Noone was from Manchester, and he was (badly)
mimicking a Cockney accent. If (God forbid) you want to hear a real Cockney
sing it, then listen to Joe Brown and the Bruvvers. But it's only for the
tourists, we don't really speak like that, most Brits are far more obscure,
I can't understand them .

"Dave Peterson" wrote in message
...
"I'm 'enery the 8th, I am. 'Enery the 8th, I am, I am...."

http://www.peternoone.com/lyrics/henry8.html

Peter Noone didn't lose his accent.


--

Dave Peterson
  #15   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default projecting sales for month

Speaking of stereotypes, time to oil your collection of rifles, jump into
your 8mpg RV, deny global warming, and rush down to the Heart Attack Grill,
they have got quadruple bypass burgers now.


"Dave Peterson" wrote in message
...
By George, I think you've got it!

Where does that rain fall?

Bob Phillips wrote:

No, he put it on. Peter Noone was from Manchester, and he was (badly)
mimicking a Cockney accent. If (God forbid) you want to hear a real

Cockney
sing it, then listen to Joe Brown and the Bruvvers. But it's only for

the
tourists, we don't really speak like that, most Brits are far more

obscure,
I can't understand them .

"Dave Peterson" wrote in message
...
"I'm 'enery the 8th, I am. 'Enery the 8th, I am, I am...."

http://www.peternoone.com/lyrics/henry8.html

Peter Noone didn't lose his accent.


--

Dave Peterson





  #16   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,345
Default projecting sales for month

No, he put it on. Peter Noone was from Manchester, and he was (badly)
mimicking a Cockney accent.


It probably only works verbally but it reminds me of the little cockney
fellow who was sent to the front line in the First World War.

The Captain said to him, "Well my man, have you come here to die?" - for it
was a terrible time of death and destruction was the First World War.

"Well my man," said the Captain, "have you come here to die?"

And the little cockney answered, "No! I came here yester-die!"

--
I hope that it survives translation.


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Bob Phillips" wrote in message
...
No, he put it on. Peter Noone was from Manchester, and he was (badly)
mimicking a Cockney accent. If (God forbid) you want to hear a real
Cockney
sing it, then listen to Joe Brown and the Bruvvers. But it's only for the
tourists, we don't really speak like that, most Brits are far more
obscure,
I can't understand them .



"Dave Peterson" wrote in message
...
"I'm 'enery the 8th, I am. 'Enery the 8th, I am, I am...."

http://www.peternoone.com/lyrics/henry8.html

Peter Noone didn't lose his accent.






  #17   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default projecting sales for month

Without my stereotypes, life gets a lot more complex (and makes my head hurt!).

Bob Phillips wrote:

Speaking of stereotypes, time to oil your collection of rifles, jump into
your 8mpg RV, deny global warming, and rush down to the Heart Attack Grill,
they have got quadruple bypass burgers now.

"Dave Peterson" wrote in message
...
By George, I think you've got it!

Where does that rain fall?

Bob Phillips wrote:

No, he put it on. Peter Noone was from Manchester, and he was (badly)
mimicking a Cockney accent. If (God forbid) you want to hear a real

Cockney
sing it, then listen to Joe Brown and the Bruvvers. But it's only for

the
tourists, we don't really speak like that, most Brits are far more

obscure,
I can't understand them .

"Dave Peterson" wrote in message
...
"I'm 'enery the 8th, I am. 'Enery the 8th, I am, I am...."

http://www.peternoone.com/lyrics/henry8.html

Peter Noone didn't lose his accent.


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add Sales Goals to Sales Report in Pivot Table Ronster Excel Discussion (Misc queries) 1 October 13th 06 04:17 AM
figuring commissions based on gross sales rjhocker Excel Worksheet Functions 1 September 12th 06 09:07 PM
sales needed to cover costs that increase as sales do donna-LexusWebs Excel Worksheet Functions 5 August 29th 06 06:17 PM
Projecting sales dollars based on actual history Bruce Excel Worksheet Functions 2 January 14th 06 07:49 PM
Calculate Total Sales from a Database John Excel Worksheet Functions 0 November 3rd 05 12:26 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"