corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » General Chat » Formula for Excel


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Formula for Excel
Adam
Member
Registered: 1st May 01
Location: Hurstbourne Tarrant
User status: Offline
24th Sep 03 at 19:06   View User's Profile U2U Member Reply With Quote
Brain's stopped working

1145-17.5%

I'm getting 1145 :S:S
mattyboy199
Member
Registered: 5th Feb 03
User status: Offline
24th Sep 03 at 19:08   View User's Profile U2U Member Reply With Quote
+(1145)*117.5%


thats it type that in a cell
mattyboy199
Member
Registered: 5th Feb 03
User status: Offline
24th Sep 03 at 19:10   View User's Profile U2U Member Reply With Quote
or jus +1145*117.5%
Adam
Member
Registered: 1st May 01
Location: Hurstbourne Tarrant
User status: Offline
24th Sep 03 at 19:10   View User's Profile U2U Member Reply With Quote
that makes 1345
Adam
Member
Registered: 1st May 01
Location: Hurstbourne Tarrant
User status: Offline
24th Sep 03 at 19:11   View User's Profile U2U Member Reply With Quote
need to be / not *

cheers
mattyboy199
Member
Registered: 5th Feb 03
User status: Offline
24th Sep 03 at 19:11   View User's Profile U2U Member Reply With Quote
which is correct
Adam
Member
Registered: 1st May 01
Location: Hurstbourne Tarrant
User status: Offline
24th Sep 03 at 19:11   View User's Profile U2U Member Reply With Quote
2nd
mattyboy199
Member
Registered: 5th Feb 03
User status: Offline
24th Sep 03 at 19:13   View User's Profile U2U Member Reply With Quote
+1145*0.825

try that
Adam
Member
Registered: 1st May 01
Location: Hurstbourne Tarrant
User status: Offline
24th Sep 03 at 19:13   View User's Profile U2U Member Reply With Quote
=1145/117.5%
Drew
Banned
Registered: 24th Nov 01
Location: County Durham
User status: Offline
24th Sep 03 at 19:15   View User's Profile U2U Member Reply With Quote
sorry that dont work - if u divide by 117.5% u wont be taking off 17.5%
Drew
Banned
Registered: 24th Nov 01
Location: County Durham
User status: Offline
24th Sep 03 at 19:18   View User's Profile U2U Member Reply With Quote
to find out the vat on something - u x7 then /47

eg - 117.5 x 7 /47 = 17.5
Adam
Member
Registered: 1st May 01
Location: Hurstbourne Tarrant
User status: Offline
24th Sep 03 at 19:22   View User's Profile U2U Member Reply With Quote
fank you
Drew
Banned
Registered: 24th Nov 01
Location: County Durham
User status: Offline
24th Sep 03 at 19:26   View User's Profile U2U Member Reply With Quote
no probs - i am helpful sometimes ya know lol
Adam
Member
Registered: 1st May 01
Location: Hurstbourne Tarrant
User status: Offline
24th Sep 03 at 19:29   View User's Profile U2U Member Reply With Quote
only £6 in it so I just averaged it

 
New Topic
New Poll

Corsa Sport » Message Board » General Chat » Formula for Excel 22 database queries in 0.0109539 seconds