ScoobyNet.com - Subaru Enthusiast Forum

Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel - Basic question

Thread Tools
 
Search this Thread
 
Old 20 June 2008, 06:12 PM
  #1  
JackClark
Scooby Senior
Thread Starter
 
JackClark's Avatar
 
Join Date: Dec 2000
Location: Overdosed on LCD
Posts: 20,852
Received 51 Likes on 34 Posts
Default Excel - Basic question
Got to admit, I'm rubbish! I usually get by but this one has me tearing my hair out as I can imagine it's very easy.

I'm trying to make an invoice and expenses template. Can I SUM a column - my phone bill - then *1.175 for VAT all in one cell? I can do one at a time just fine, but would like to do both in one.

My explanation is probably as bad as my functions.
JackClark is offline  
Reply Like
Old 20 June 2008, 06:16 PM
  #2  
DemonDave
Scooby Regular
iTrader: (13)
 
DemonDave's Avatar
 
Join Date: Jan 2001
Location: Midlands - between notts and derby !
Posts: 4,997
Likes: 0
Received 0 Likes on 0 Posts
Default
=SUM(F10:F13)*1.175
DemonDave is offline  
Reply Like
Old 20 June 2008, 06:17 PM
  #3  
JackClark
Scooby Senior
Thread Starter
 
JackClark's Avatar
 
Join Date: Dec 2000
Location: Overdosed on LCD
Posts: 20,852
Received 51 Likes on 34 Posts
Default
That's what I've been trying but it's not having it. I'll give it another go.
JackClark is offline  
Reply Like
Old 20 June 2008, 06:20 PM
  #4  
JackClark
Scooby Senior
Thread Starter
 
JackClark's Avatar
 
Join Date: Dec 2000
Location: Overdosed on LCD
Posts: 20,852
Received 51 Likes on 34 Posts
Default
<slaps face> tried again and it worked perfectly, thanks Dave.
JackClark is offline  
Reply Like
Old 20 June 2008, 06:22 PM
  #5  
DemonDave
Scooby Regular
iTrader: (13)
 
DemonDave's Avatar
 
Join Date: Jan 2001
Location: Midlands - between notts and derby !
Posts: 4,997
Likes: 0
Received 0 Likes on 0 Posts
Default
LOL - sods law
DemonDave is offline  
Reply Like
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
BUGEYE PRODRIVE STI BREAKING(rota's/racebox/whiteline/cusco/prodrive styling/6speed+
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
*** ESOC Pub Meets 2016 ***
Frizzle-Dee
Essex Subaru Owners Club
13
01 December 2015 09:37 AM
Newage Hayward and Scott 2.5" exhaust system
has-scooby
Subaru Parts
4
06 October 2015 03:47 PM
Handling issue.
PetrolHeadKid
Driving Dynamics
10
05 October 2015 05:19 PM
Range of hose/fitting available @ Pro-Line.
Pro-Line Motorsport
Car Parts For Sale
2
29 September 2015 07:36 PM
Back to Subforum
Computer & Technology Related
View Next Unread
BE Broadband




Advanced Search
Quick Reply: Excel - Basic question


Reply Closed Thread Share
Forum Jump

All times are GMT +1. The time now is 10:08 AM.