Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-22-2009, 07:04 PM
praveen_p praveen_p is offline
Novice
Basic operation of Excel not working!
 
Join Date: Apr 2009
Posts: 3
praveen_p is on a distinguished road
Post Basic operation of Excel not working!

Some of basic operation are not working in excel.can u suggest me the correct format of operation of addition,sub,mul,div etc.
Reply With Quote
  #2  
Old 04-23-2009, 04:29 AM
thhui thhui is offline Basic operation of Excel not working! Windows 2K Basic operation of Excel not working! Office XP
Novice
 
Join Date: Mar 2009
Posts: 6
thhui is on a distinguished road
Default

Excel Formula for addition, multiplication, division and subtraction
=1+1
=1*2
=9/3
=1-1
Reply With Quote
  #3  
Old 04-23-2009, 10:21 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Basic operation of Excel not working! Basic operation of Excel not working! Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Wink

Quote:
Originally Posted by praveen_p View Post
Some of basic operation are not working in excel.can u suggest me the correct format of operation of addition,sub,mul,div etc.

You are sticking to the BODMAS rules, aren't you
  • Brackets - annything in brackets gets done first (restart BODMAS)
  • Order - Powers of, or order second, ie: 2 squared
  • Division - If equations are not segregated by brackets, then this is the first.
  • Multiplication - the next math function
  • Addition - comes towards the end
  • Subtraction - is the final mathematical operator
Examples:
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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic operation of Excel not working! how do I activate office basic? madyfb Office 1 05-21-2009 11:18 AM
working with html kate1234 Word 0 09-22-2008 05:02 PM
Basic operation of Excel not working! A little Visual Basic Help Please 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft