LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default using mathmatical symbols in cells

On Jan 2, 11:24*am, Dana DeLouis wrote:
* 6+2/2=4

Hi. *I saw that as one of the few "close" matches also, but my program
gave 6+1 = 7, and not 4. *Did I do something wrong?
Thanks.
Dana


That's what I meant by NOT using the typical rule of * / before + -.
Excel or whatever system will follow this rule and do multiplication
first. But this is a paper brain teaser. You have to do it in the
order listed on the paper. If you are using a formula, maybe put
parentheses around the first calc to make sure it goes first.

I just did it in my head. I can break the rules, Excel can't. ;-)


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mathmatical functions in Excel MAC JUNIOR Excel Worksheet Functions 4 September 23rd 08 03:58 PM
Symbols inside cells Jedi_Wcu4 Excel Discussion (Misc queries) 2 January 17th 06 12:18 AM
symbols in cells Oni Excel Discussion (Misc queries) 2 April 25th 05 11:09 AM
mathmatical error CRatt Excel Worksheet Functions 2 February 16th 05 03:44 AM
How to set up a graph for mathmatical graphing mike71366 Setting up and Configuration of Excel 0 December 10th 04 03:09 PM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"