Hi all,

I have a look up function in a spreadsheet that returns a number, call
it 20. What I want to do is to have a formula that says "when you find
20, multiply cell 1A x cell 1D x cell 1F and return its numeric value
(or product if you like)"

Thanks a lot

Try this...

Cell being tested is G1:

=If(G1 = 20,A1*D1*F1,"")

If G1 = 20, the cell in which you copy the formula will be the product of
A1, D1, and F1. Otherwise, the cell will be empty.

"Vince" wrote:

Hi all,

I have a look up function in a spreadsheet that returns a number, call
it 20. What I want to do is to have a formula that says "when you find
20, multiply cell 1A x cell 1D x cell 1F and return its numeric value
(or product if you like)"

Thanks a lot