Simple formula for newbie!

  • Thread starter Thread starter TC
  • Start date Start date
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
 
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
 
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
 
Back
Top