Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas containing more than one 'operator'
Hi all
I have a formula and am struggling to get the correct answer. As the calculation contains more than one 'operator, i need to use brackets, however, I'm not entirely sure where these should go. My calculation is =10+10*2+2*10 My total should therefore be 420. Where do the brackets go in order to get to the right answer??? Thank you. Louise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas containing more than one 'operator'
=(((10+10)*2)+2)*10
Try pressing F1 & read up Excel Help. You may like to search the help for title "The order in which Microsoft Excel performs operations in formulas" HTH -- Edmund (Using Excel XP) "Louise" wrote: Hi all I have a formula and am struggling to get the correct answer. As the calculation contains more than one 'operator, i need to use brackets, however, I'm not entirely sure where these should go. My calculation is =10+10*2+2*10 My total should therefore be 420. Where do the brackets go in order to get to the right answer??? Thank you. Louise |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulas containing more than one 'operator'
Try =((10+10)*2+2)*10 -- Louise Wrote: Hi all I have a formula and am struggling to get the correct answer. As the calculation contains more than one 'operator, i need to use brackets, however, I'm not entirely sure where these should go. My calculation is =10+10*2+2*10 My total should therefore be 420. Where do the brackets go in order to get to the right answer??? Thank you. Louise -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=542051 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy only cells with formulas in another row? | Excel Worksheet Functions | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |