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 » Post Reply

Post Reply
Who Can Post? All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help
Insert Bold text Insert Italicized text Insert Underlined text Insert Centered text Insert a Hyperlink Insert Email Hyperlink Insert an Image Insert Code Formatted text Insert Quoted text
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
Post Options: Disable smileys?
Turn BBCode off?
Receive email notification of new replies?

Adam

 posted on 24th Sep 03 at 19:29

only £6 in it so I just averaged it


Drew

 posted on 24th Sep 03 at 19:26

no probs - i am helpful sometimes ya know lol


Adam

 posted on 24th Sep 03 at 19:22

fank you


Drew

 posted on 24th Sep 03 at 19:18

to find out the vat on something - u x7 then /47

eg - 117.5 x 7 /47 = 17.5


Drew

 posted on 24th Sep 03 at 19:15

sorry that dont work - if u divide by 117.5% u wont be taking off 17.5%


Adam

 posted on 24th Sep 03 at 19:13

=1145/117.5%


mattyboy199

 posted on 24th Sep 03 at 19:13

+1145*0.825

try that


Adam

 posted on 24th Sep 03 at 19:11

2nd


mattyboy199

 posted on 24th Sep 03 at 19:11

which is correct


Adam

 posted on 24th Sep 03 at 19:11

need to be / not *

cheers :D


Adam

 posted on 24th Sep 03 at 19:10

that makes 1345


mattyboy199

 posted on 24th Sep 03 at 19:10

or jus +1145*117.5%


mattyboy199

 posted on 24th Sep 03 at 19:08

+(1145)*117.5%


thats it type that in a cell


Adam

 posted on 24th Sep 03 at 19:06

Brain's stopped working

1145-17.5%

I'm getting 1145 :S:S