Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |