Help with automation of accounts recording

[MrNasty]

My current sheet is as follows:

Unit Amount
Price Per Unit
Total Price

I would like to automate that If I type in any 2 values the third is automated however excel does not seem to allow me to do this. I would like all the formulas below to work in unison.


Unit Amount Price Per Unit Total Price
1000 1.23 1230=Unit Amount * Price Per Unit
1000 1.23=Total Price / Unit Amount 1230
1000=Total Price / Price Per Unit 1.23 1230

Whenever I try to add more than one formula It creates a blue line with arrows either side and locks the cells.


Any help would be greatly appreciated thank you.

[torachan]

a worksheet is far better to work with than words
see big yellow banner - how to upload your workbook.
torachan.