need HELP with simple excel formula!

  • Thread starter Thread starter Danni2008
  • Start date Start date
D

Danni2008

I'm trying to come up with a basic formula today!

I want to find how to write a formula where I want to basically find out:
if A1 is >1, then multiply by cell B2 - otherwise (if not true), multiple by
cell B1)

Any help?
Thanks in advance
 
Basic formula with no error trapping..............

=IF(A1>1,A1*B2,A1*B1)


Gord Dibben MS Excel MVP
 
Interesting... both Mike and Gord opted to perform the multiplication inside
the true and false conditions of the IF function. Since the value being
multiplied is the same (A1), my preference would be to multiple it by the
result of the IF statement...

=A1*IF(A1>1,B2,B1)

Rick
 
Back
Top