Home |
Search |
Today's Posts |
|
UK diy (uk.d-i-y) For the discussion of all topics related to diy (do-it-yourself) in the UK. All levels of experience and proficency are welcome to join in to ask questions or offer solutions. |
|
LinkBack | Thread Tools | Display Modes |
#1
Posted to uk.d-i-y
|
|||
|
|||
OT MS Excel
I'm confused! Normally good with Excel, but this has got me puzzled.
Using the formula =(B16*C16)*D16 - where, in this example B16 is 10, C16 is 2.36 * D16 is 1. So, Excel should first perform the multiplication in brackets, the multiply the answer by D16. So 10 x 2.36 is 23.6. Multiply that by 1 and it's 23.6. Excel makes it 24.31? The figures are only a simple example, all the calculations are equally wrong when this formula is used. What am I doing wrong. Where is my beer? -- Dave - The Medway Handyman www.medwayhandyman.co.uk 01634 717930 07850 597257 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Programming Using VBA | UK diy | |||
Mira Excel B | UK diy | |||
1996 Hyundai Excel lx | Electronics Repair | |||
Mira Excel problem | UK diy |