Yorkshire Divers

Dive Logs
Go Back   YD Scuba Diving Forums > Non-Diving Related Forums > Non Diving Posts
Excel Help Required Excel Help Required
User Name
Password

Welcome to the YD Scuba forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

Non Diving Posts: Discuss Excel Help Required in the Non-Diving Related Forums forums: Ok. Excel is doing my head in as I can't sort out a formulae. Help from the YD Masses before ...

Reply
Page 1 of 2 1 2 >
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 27-07-07, 11:03 AM
kath2407's Avatar
Swims with More Seals
  

Join Date: Jul 2004
Location: Leeds
Posts: 1,985
Thanks: 0
Thanked 0 Times in 0 Posts
kath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold water
Excel Help Required
Ok. Excel is doing my head in as I can't sort out a formulae. Help from the YD Masses before my budget collapses!!

We sell tickets for an event. We record this as income i.e. a negative number in excel

Our venue holds 1000 people and the average ticket price is £10.

So if we receive £80,000 in income it is indicating that we held 8 gigs (variables excepted!! They're not all sold out and ticket values differ but thats too complicated!)

So we pass on the ticket income to the promoter, less our fee for using our facilities - usually around £3k.

So I have income (E7) -80,000

Amount to refund to promoter =E7-((E7/1000/10)*3000)

But of course the solution to the formulae is -56,000

But this is an expenses so I need to turn my negative into a positive?????


HELP!!!!!

K XX
__________________
why shouldn't divers have a dirty sense of humour - we go down, we get wet, we wear rubber!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 27-07-07, 11:05 AM
Finless's Avatar
Finless: You couldn't invent him...
  
Asteroids Champion!
Join Date: Apr 2003
Location: Bexhill, East Sx.
Posts: 14,892
Thanks: 2
Thanked 7 Times in 5 Posts
Finless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the water
Times minus one?
__________________
Citius, Altius, Fortius? No: Lower, Slower, Fatter.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 27-07-07, 11:07 AM
Scuttler's Avatar
Eats curry for breakfast, dinner and lunch. Yummy
  

Join Date: Jan 2006
Location: Weymouth, Dorset
Posts: 5,191
Thanks: 0
Thanked 0 Times in 0 Posts
Scuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fish
Quote:
Originally Posted by kath2407
Ok. Excel is doing my head in as I can't sort out a formulae. Help from the YD Masses before my budget collapses!!

We sell tickets for an event. We record this as income i.e. a negative number in excel

Our venue holds 1000 people and the average ticket price is £10.

So if we receive £80,000 in income it is indicating that we held 8 gigs (variables excepted!! They're not all sold out and ticket values differ but thats too complicated!)

So we pass on the ticket income to the promoter, less our fee for using our facilities - usually around £3k.

So I have income (E7) -80,000

Amount to refund to promoter =E7-((E7/1000/10)*3000)

But of course the solution to the formulae is -56,000

But this is an expenses so I need to turn my negative into a positive?????


HELP!!!!!

K XX

Try

=-(E7-((E7/1000/10)*3000))
__________________
...---...


5 Minute Neuro Exam


Fish are food not friends
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 27-07-07, 11:08 AM
Scuttler's Avatar
Eats curry for breakfast, dinner and lunch. Yummy
  

Join Date: Jan 2006
Location: Weymouth, Dorset
Posts: 5,191
Thanks: 0
Thanked 0 Times in 0 Posts
Scuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fish
Quote:
Originally Posted by Finless
Times minus one?
or that
__________________
...---...


5 Minute Neuro Exam


Fish are food not friends
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 27-07-07, 11:08 AM
Finless's Avatar
Finless: You couldn't invent him...
  
Asteroids Champion!
Join Date: Apr 2003
Location: Bexhill, East Sx.
Posts: 14,892
Thanks: 2
Thanked 7 Times in 5 Posts
Finless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the water
Also, I would recommend using the 'bracket' number format to report credits. It is much easier on the eye and easier to spot?
__________________
Citius, Altius, Fortius? No: Lower, Slower, Fatter.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 27-07-07, 11:09 AM
kath2407's Avatar
Swims with More Seals
  

Join Date: Jul 2004
Location: Leeds
Posts: 1,985
Thanks: 0
Thanked 0 Times in 0 Posts
kath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold waterkath2407 swims in cold water
Quote:
Originally Posted by Scuttler
Try

=-(E7-((E7/1000/10)*3000))
and a big fat sloppy kiss for Mr Scuttler!!!!!!!!!!!

My budget is saved!!!!!

Altho now slapping myself round the head for being so stupid not to be able to figure it out for myself!

K XX
__________________
why shouldn't divers have a dirty sense of humour - we go down, we get wet, we wear rubber!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 27-07-07, 11:10 AM
Finless's Avatar
Finless: You couldn't invent him...
  
Asteroids Champion!
Join Date: Apr 2003
Location: Bexhill, East Sx.
Posts: 14,892
Thanks: 2
Thanked 7 Times in 5 Posts
Finless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the water
Come on Kath, we wan't to read a "Doh"!

__________________
Citius, Altius, Fortius? No: Lower, Slower, Fatter.
Last edited by Finless : 27-07-07 at 11:12 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 27-07-07, 11:13 AM
Finless's Avatar
Finless: You couldn't invent him...
  
Asteroids Champion!
Join Date: Apr 2003
Location: Bexhill, East Sx.
Posts: 14,892
Thanks: 2
Thanked 7 Times in 5 Posts
Finless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the waterFinless is never out of the water
Quote:
Originally Posted by kath2407
and a big fat sloppy kiss for Mr Scuttler!!!!!!!!!!!






__________________
Citius, Altius, Fortius? No: Lower, Slower, Fatter.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 27-07-07, 11:21 AM
Scuttler's Avatar
Eats curry for breakfast, dinner and lunch. Yummy
  

Join Date: Jan 2006
Location: Weymouth, Dorset
Posts: 5,191
Thanks: 0
Thanked 0 Times in 0 Posts
Scuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fishScuttler communes with fish
Quote:
Originally Posted by kath2407
and a big fat sloppy kiss for Mr Scuttler!!!!!!!!!!!

Many Thanks
__________________
...---...


5 Minute Neuro Exam


Fish are food not friends
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 27-07-07, 11:51 AM
Colin Marriott's Avatar
Vivo incomitatus, urino incomitatus
  

Join Date: Jul 2004
Location: Leeds
Posts: 1,961
Thanks: 3
Thanked 6 Times in 6 Posts
Colin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fishColin Marriott communes with fish
Should have used
=ABS(E7-((E7/1000/10)*3000)))

But never mind


ColinM
__________________
"Opinions vary"
http://uk.youtube.com/profile_videos?user=colinmarriott
http://www.imgtec.com/
Q. Why did the razorbill raise her bill?

A. So the sea urchin could see her chin!
(\__/)
(>'.'<)
(")_(")
Αυτό είναι όλα τα ελληνικά μου!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 1 of 2 1 2 >

« True friendship...... | Steven »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Sponsored Links

Yorkshire Divers - RSS Feed
All times are GMT +1. The time now is 07:07 PM.
Powered by vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0
Trademark and all rights reserved : © YD.com Ltd (2006)
YD.com Ltd (Registered in England - 05886696)
Other sites : Golf Clubs | New Premiership Football Kits | MP3 Portable Players | MP3 Players For Sale | Replica Football Kits | Cheap Football Boots | Compare MP3 Player Prices | Cheap Christmas Gift Ideas | Cheap Replica Shirt

Advertise - Contact Us - Yorkshire Divers - Sitemap - Privacy Statement - Terms & Conditions - Top
Forums Directory