Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » BODMAS
Resolved · Low Priority · Version 2007
Katrina has attended:
Excel Introduction course
Word Intermediate course
Not sure of this..how is =A1+B1*C1 equal 7?
Hi Katrina, Thank you for your post, welcome to the forum, I hope you enjoyed the Excel 2007 intro course, in answer to your question, and a good one it is too; BODMAS stands for Brackets, Ordinals (raised to the power of), Division, Multiplication, Addition and Subtraction, this is the sequence that Excel (and Access) follow when calculating, in the case that you have mentioned the figures in the cells will be considered by Excel and calculated in the order laid down by BODMAS, in this case because Multiplication comes before Addition it will calculate B1*C1 and then add A1 to the value, so where A1 = 1 B1 = 2 and C1 = 3, 3*2=6 +1 = 7. Its all down to the sequence that Excel follows. I hope that helped, if it did please click the resolved button, hope to see you again on the forum soon, best regards Pete.
|
Excel tip:Moving between Worksheets without using the mouseUse the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys. |
We'll call during UK business hours
Server loaded in 0.08 secs.