SunQuest
 
           ASP Free Lounge
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Other > ASP Free Lounge
Reload this Page

Excel Calculations

Discuss Excel Calculations in the ASP Free Lounge forum on ASP Free.
Excel Calculations ASP development forum discussing anything that doesn't fit into the other forums. This is the place to relax, talk, and maybe even have some friendly debate.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!
  #1  
Old March 3rd, 2004, 06:31 AM
Annie112 Annie112 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 1 Annie112 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy Excel Calculations
Hi,

I appreciate this is basic maths - not my hot point!!

I need to return a monitary value as a percentage.

So say £270.00 - £95.00 = £175.00 therefore what % is the 175 of 270

This will be a recurring calulation for varying amounts.

Basically I am calculating the gross margin, minus overheads etc. to get the net
profit and then show this as a percentage.

I just cant get my head around the formula.

Any help would be very welcome and many thanks
Annie
Reply With Quote
  #2  
Old March 8th, 2004, 10:17 PM
sbaxter sbaxter is offline
Moderator: Access, SQL
ASP Free God (5000 - 5499 posts)
  
Join Date: Oct 2003
Posts: 5,126 sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level)sbaxter User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 4 Days 1 h 2 m 51 sec
Reputation Power: 12
£270.00 - £95.00 = £175.00 therefore what % is the 175 of 270


Assuming
Cell A1 holds 270
Cell B1 holds 95

(A1-B1)/A1


S-
Reply With Quote
Reply

Viewing: ASP Free Forums > Other > ASP Free Lounge > Excel Calculations

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


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
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway.