need HELP with simple excel formula!

[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

 

[Mike H]

Try

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

Mike

 

[Gord Dibben]

Basic formula with no error trapping..............

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


Gord Dibben MS Excel MVP

 

[Danni2008]

THANK YOU SO MUCH, IT WORKED!

Try

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

Mike

 

[Danni2008]

THANKS, THAT WORKS!! D

Basic formula with no error trapping..............

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


Gord Dibben MS Excel MVP

 

[Rick Rothstein \(MVP - VB\)]

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