View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony D Anthony D is offline
external usenet poster
 
Posts: 78
Default Whatsthe formula which retrieves a # from a multiplication table

Hi DS,

It looks as if a3 could contain the formula:
=a1*a2

Hope that helps ?
Anthony

"DS" wrote:

I have a table that is similar to a multiplication table.
I would like to write a formula in a single cell (example A3) that retrieves
data from a table by matching values typed in cells A1 and A2
(Example1: A1 has the number 5 typed in and A2 has the number 10 typed in).
A3 should result with a 50.)
(Example2: A1 has the number 6 typed in and A2 has the number 3 typed in).
A3 should result with a 18.)