View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default using mathmatical symbols in cells


Hi. I pulled up all "permutations" of "+-*/" and even "+-*/^" and did
not show a solution. Are you sure you copied the problem correctly?
- - -
Dana DeLouis


GO wrote:
I am trying to re-create a brain teaser from the newspaper on an excel spread
sheet. The aim is to have two rows and two columns of numbers interlaced and
the four mathmatical symbols used once each so that both the rows and columns
sum to the same amount.

e.g. (this is not solved!)

2 10
6 / 2 - 2
2 2
3 + 2 * 2
1 1

I would like to put mathmatical symbols in cells to form each equation, so
that I can change the symbol and both row and coloumn up-dates. Has anyone
done something like this?

Thanks.