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
Try
=((10 10)*2 2)*10
--
Louise Wrote:
gt; Hi all
gt;
gt; I have a formula and am struggling to get the correct answer. As the
gt; calculation contains more than one 'operator, i need to use brackets,
gt; however, I'm not entirely sure where these should go.
gt;
gt; My calculation is =10 10*2 2*10
gt;
gt; My total should therefore be 420.
gt;
gt; Where do the brackets go in order to get to the right answer???
gt;
gt; Thank you.
gt; Louise--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=542051=(((10 10)*2) 2)*10
Try pressing F1 amp; read up Excel Help. You may like to search the help for
title quot;The order in which Microsoft Excel performs operations in formulasquot;
HTH
--
Edmund
(Using Excel XP)quot;Louisequot; wrote:
gt; Hi all
gt;
gt; I have a formula and am struggling to get the correct answer. As the
gt; calculation contains more than one 'operator, i need to use brackets,
gt; however, I'm not entirely sure where these should go.
gt;
gt; My calculation is =10 10*2 2*10
gt;
gt; My total should therefore be 420.
gt;
gt; Where do the brackets go in order to get to the right answer???
gt;
gt; Thank you.
gt; Louise
- Nov 18 Sat 2006 20:10
formulas containing more than one 'operator'
close
全站熱搜
留言列表
發表留言