| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 107844 | 2010-03-03 20:36:00 | EXCEL question | prefect (6291) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 863742 | 2010-03-04 02:20:00 | Thanks AvonBill Yes, prefect, I just used "11.25" because I knew it would result in a nice round result: "10" If I had used "10", the result would have been "8.89", or "12.5" the answer would have been a very messy "11.1111111111111111"... |
johcar (6283) | ||
| 863743 | 2010-03-04 04:01:00 | Thanks AvonBill Yes, prefect, I just used "11.25" because I knew it would result in a nice round result: "10" If I had used "10" , the result would have been "8.89", or "12.5" the answer would have been a very messy "11.1111111111111111"... Prefect, to expand on this, you need to format the results column for 2 decimal places so in Johcar's example, you'd end up with 11.11 PM me if you want any how to tips. |
WalOne (4202) | ||
| 863744 | 2010-03-04 04:32:00 | Thanks heaps guys for replies, yes formatted cells as currency to 2 decimal places. Its up and running saved me mate hours of calculations. Went back to my truck and hour ago and there are 12 cans of woodies on the front seat. Had told him not to bother mates dont have to pay anything but he didnt take any notice. |
prefect (6291) | ||
| 863745 | 2010-03-04 05:11:00 | That's funny - thought I just heard one of those Woodies being opened.... :D | johcar (6283) | ||
| 863746 | 2010-03-04 05:17:00 | 11.25 =A1-(A1/9) (result = "10") (where the value "11.25" is in cell A1) Why not just divide by 1.125 ? |
TeejayR (4271) | ||
| 863747 | 2010-03-04 05:57:00 | Cos that's too easy.... | johcar (6283) | ||
| 863748 | 2010-03-04 06:10:00 | Why not just divide by 1.125 ? There's all sorts of ways of arriving at the same answer ;) In the meantime, the time to send some Woodies from Whest Auckland to the Centre of the Universe at Ellerslie is only 45 minutes at most. I am awaiting my share in breathless anticip ........................ation. ;) |
WalOne (4202) | ||
| 863749 | 2010-03-04 06:17:00 | There's all sorts of ways of arriving at the same answer ;) In the meantime, the time to send some Woodies from Whest Auckland to the Centre of the Universe at Ellerslie is only 45 minutes at most. I am awaiting my share in breathless anticip ........................ation. ;) I have dealt to 2 of them already WAL so I cant drive to Ellerslie! |
prefect (6291) | ||
| 863750 | 2010-03-04 06:31:00 | There's all sorts of ways of arriving at the same answer ;) In the meantime, the time to send some Woodies from Whest Auckland to the Centre of the Universe at Ellerslie is only 45 minutes at most. I am awaiting my share in breathless anticip ........................ation. ;) But last time I looked the Ellerslie Flower show is in Christchurch.:clap |
Sweep (90) | ||
| 863751 | 2010-03-04 07:44:00 | But last time I looked the Ellerslie Flower show is in Christchurch.:clap Rumour is, next year's Ellerslie Flower Show will be held at Taihape, where they'll place flowers in gumboots and throw them down the main street. :horrified |
WalOne (4202) | ||
| 1 2 | |||||