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 Jun 20, 2008 | 06:12 PM
Share
  #1  
JackClark's Avatar
JackClark
Thread Starter
Scooby Senior
25 Year Member
Liked
Loved
Community Favorite
 
Joined: Dec 2000
Posts: 20,896
Likes: 53
From: Overdosed on LCD
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.
Reply
0
Old Jun 20, 2008 | 06:16 PM
Share
  #2  
DemonDave's Avatar
DemonDave
Scooby Regular
iTrader: (13)
 
Joined: Jan 2001
Posts: 4,997
Likes: 0
From: Midlands - between notts and derby !
Default
=SUM(F10:F13)*1.175
Reply
0
Old Jun 20, 2008 | 06:17 PM
Share
  #3  
JackClark's Avatar
JackClark
Thread Starter
Scooby Senior
25 Year Member
Liked
Loved
Community Favorite
 
Joined: Dec 2000
Posts: 20,896
Likes: 53
From: Overdosed on LCD
Default
That's what I've been trying but it's not having it. I'll give it another go.
Reply
0
Old Jun 20, 2008 | 06:20 PM
Share
  #4  
JackClark's Avatar
JackClark
Thread Starter
Scooby Senior
25 Year Member
Liked
Loved
Community Favorite
 
Joined: Dec 2000
Posts: 20,896
Likes: 53
From: Overdosed on LCD
Default
<slaps face> tried again and it worked perfectly, thanks Dave.
Reply
0
Old Jun 20, 2008 | 06:22 PM
Share
  #5  
DemonDave's Avatar
DemonDave
Scooby Regular
iTrader: (13)
 
Joined: Jan 2001
Posts: 4,997
Likes: 0
From: Midlands - between notts and derby !
Default
LOL - sods law
Reply
0
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
Dec 28, 2015 11:07 PM
*** ESOC Pub Meets 2016 ***
Frizzle-Dee
Essex Subaru Owners Club
13
Dec 1, 2015 09:37 AM
Newage Hayward and Scott 2.5" exhaust system
has-scooby
Subaru Parts
4
Oct 6, 2015 03:47 PM
Handling issue.
PetrolHeadKid
Driving Dynamics
10
Oct 5, 2015 05:19 PM
Range of hose/fitting available @ Pro-Line.
Pro-Line Motorsport
Car Parts For Sale
2
Sep 29, 2015 07:36 PM
Back to Subforum
Computer & Technology Related
View Next Unread
BE Broadband




Advanced Search
Reply Closed Thread Share
Forum Jump

All times are GMT +1. The time now is 01:35 PM.