working VAT in worksheet
No, as I said
"You can't have a function in a cell then enter something in that same cell"
Meaning that if you have a function in F12 to calculate the total then you
can't type in the total in the same cell, once you do you clear out the
function.
--
Regards,
Peo Sjoblom
"Tina Harrison" wrote in message
...
I don't think i explained myself very well.
I need to enter data in either F9 or H9
so if i enter data in F9 the answer will be in H9 and vise versa
and then maybe enter a formula in G10 to show the VAT.
Can this be done?
Thank you for your help
Tina
"Peo Sjoblom" wrote:
You can't have a function in a cell then enter something in that same
cell
So if you create a 4th and 5th column
to get the Net if you enter something in the total use
=F10/(1+17.5%)
to get the VAT
=F10-(F10/(1+17.5%))
If you put in the Net in F8
then use
=F8*17.5%
to get the VAT
and
=F8*(1+17.5%)
to get the total
--
Regards,
Peo Sjoblom
"Tina Harrison" wrote in message
...
Hi all
I have a worksheet like below, It might be easy for some but i'm a bit
rusty.
F8 F9 F10
Net VAT Total
What i need is a function that will allow me to enter a amount in
either
Net
or Total and it would work out Vat and either Net or Total depending
where
i
have put the amount. Hope this makes sense!
Many thanks
Tina
|