Simple formula for newbie!

T

TC

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
 
B

Bill Ridgeway

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
 
R

Route2391

I got a lot of my begginer help on this site... cool
They teach you by making a, Time sheet, Invoice and cheek book fro
scratch on Windows media Player very cool

www.MDOTutorials.co
 
Top