Any MS Excel people here?

Reply Subscribe

Thread Tools

Search this Thread

14 April 2013, 09:08 PM

LeeMac

Scooby Regular

Thread Starter

iTrader: (1)

Join Date: Aug 1999

Location: South West

Posts: 2,134

Likes: 2

Received 0 Likes on 0 Posts

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 Like

14 April 2013, 09:52 PM

jods

Scooby Senior

Join Date: Feb 2002

Location: UK

Posts: 6,645

Likes: 3

Received 0 Likes on 0 Posts

=(FEE*0.03)/100*120

Reply Like

14 April 2013, 10:17 PM

LeeMac

Scooby Regular

Thread Starter

iTrader: (1)

Join Date: Aug 1999

Location: South West

Posts: 2,134

Likes: 2

Received 0 Likes on 0 Posts

Thanks jods

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

wouldn't have known tho

cheers

Reply Like

14 April 2013, 11:06 PM

jods

Scooby Senior

Join Date: Feb 2002

Location: UK

Posts: 6,645

Likes: 3

Received 0 Likes on 0 Posts

No worries. My invoice is in the post. Double time for Sunday. :-)

Reply Like

Reply Subscribe

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 December 2015 11:07 PM

*** ESOC Pub Meets 2016 ***

Frizzle-Dee

Essex Subaru Owners Club

01 December 2015 09:37 AM

BUGEYE PRODRIVE STI BREAKING(bc br's/rota's/afterburner/6speed/ej207/brembos/prodrive

Mattybr5@MB Developments

Full Cars Breaking For Spares

18 November 2015 07:03 AM

Lateral MD321H Billet turbo

leg200

Subaru Parts

07 October 2015 07:31 AM

Newage Hayward and Scott 2.5" exhaust system

has-scooby

Subaru Parts

06 October 2015 03:47 PM

Reply Share

First
Prev
1 / 1
Next
Last

Forum Jump