TC

You'd almost got it! Try -

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

The IF - THEN - ELSE structure of your question marks you out as a probable
basic programmer and with it your possible age.

Bill Ridgeway
Computer Solutions

"TC" wrote in message
...
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