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.

Any MS Excel people here?

Thread Tools
 
Search this Thread
 
Old Apr 14, 2013 | 09:08 PM
  #1  
LeeMac's Avatar
LeeMac
Thread Starter
Scooby Regular
iTrader: (1)
 
Joined: Aug 1999
Posts: 2,134
Likes: 0
From: South West
Default Any MS Excel people here?

I'm after a formula
At the moment I have -

FEE | -3% | +VAT | Total
500 -- 15 --- 18 --- £482

How can I scale it down to -

FEE | Total -3%+VAT
500 | £482
Reply
Old Apr 14, 2013 | 09:52 PM
  #2  
jods's Avatar
jods
Scooby Senior
 
Joined: Feb 2002
Posts: 6,645
Likes: 0
From: UK
Default

=(FEE*0.03)/100*120
Reply
Old Apr 14, 2013 | 10:17 PM
  #3  
LeeMac's Avatar
LeeMac
Thread Starter
Scooby Regular
iTrader: (1)
 
Joined: Aug 1999
Posts: 2,134
Likes: 0
From: South West
Default

Thanks jods

it was =FEE-(FEE*0.03)/100*120

wouldn't have known tho

cheers
Reply
Old Apr 14, 2013 | 11:06 PM
  #4  
jods's Avatar
jods
Scooby Senior
 
Joined: Feb 2002
Posts: 6,645
Likes: 0
From: UK
Default

No worries. My invoice is in the post. Double time for Sunday. :-)
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
Dec 28, 2015 11:07 PM
Frizzle-Dee
Essex Subaru Owners Club
13
Dec 1, 2015 09:37 AM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM
leg200
Subaru Parts
5
Oct 7, 2015 07:31 AM
has-scooby
Subaru Parts
4
Oct 6, 2015 03:47 PM




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