Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default BEDMAS

Hi All,

I'm trying to create a spreadsheet that will generate an assignment
for my students on the use of "BEDMAS" - order of operations. I plan
to print it out and give it to them, and that part is working fine. I
am having trouble getting Excel to take the data and calculate it. I
know it's possible, but I just can't get it to work. :-)

Here's what I've got in cells (for example):

A B C D E F G H I J K L M N

a) ( 4 "" * "" 2 ) - "" 7 "" = ______
b) "" 3 "" + ( 4 "" * "" 8 ) = ______

I've managed to concatenate b through L so that it reads (4*2)-7, but
I can't find a way to get Excel to actually compute that answer. Is
there anyone out there that has any ideas?

Thanks in advance for your help!

Dave

 
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



All times are GMT +1. The time now is 06:40 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"