Try...

=IF(D1=10,E1*D1,F1*D1)

Hope this helps!

In article ,
"TC" wrote:

Hi

Simple question, as just starting with formulas!! But..

I need a formula whereby if cell D1 = 10, then multiply E1*D1. Else
multiply F1*D1.

Thanks!
TC