![]() |
#1
|
|||
|
|||
![]()
Some of basic operation are not working in excel.can u suggest me the correct format of operation of addition,sub,mul,div etc.
|
#2
|
|||
|
|||
![]()
Excel Formula for addition, multiplication, division and subtraction
=1+1 =1*2 =9/3 =1-1 |
#3
|
||||
|
||||
![]() Quote:
You are sticking to the BODMAS rules, aren't you
1 3*3-4+8 = 13 3*3-(4+8) = -3 2 5*5+20/5 = 29 the brackets cause no (5*5)+(20/5) = 29 change, precedence is followed, (/, *, and then +) 3 8+10/2*4+6 = 34 (8+10)/(2*4)+6 = 8.25 8+10/2*(4+6) = 58 4 4-2*8+10-3/6 = -2.5 (4-2)*8+(10-3)/6 = 17.1666 recurring (4-2)*8+10-3/6 = 25.5 5 3*2squared = 12 (Order is first, so it becomes 3*4) (3*2)squared = 25 (Brackets comes first so it becomes 5squared) Last edited by Bird_FAT; 04-24-2009 at 07:07 AM. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
madyfb | Office | 1 | 05-21-2009 11:18 AM |
working with html | kate1234 | Word | 0 | 09-22-2008 05:02 PM |
![]() |
leroytrolley | Excel | 4 | 08-22-2008 03:57 AM |
Office Basic 2007 Activation Problem | Dazza7 | Office | 0 | 07-30-2008 07:59 AM |
Need some basic help on Project | NewToProject | Project | 0 | 04-06-2008 07:03 AM |