need HELP with simple excel formula!
 

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

need HELP with simple excel formula!
 

Try

=IF(A11,A1*B2,A1*B1)

Mike

"Danni2008" wrote:

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

need HELP with simple excel formula!
 

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

=IF(A11,A1*B2,A1*B1)


Gord Dibben MS Excel MVP

On Tue, 1 Jan 2008 11:46:00 -0800, Danni2008
wrote:

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

need HELP with simple excel formula!
 

THANK YOU SO MUCH, IT WORKED!



"Mike H" wrote:

Try

=IF(A11,A1*B2,A1*B1)

Mike

"Danni2008" wrote:

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

need HELP with simple excel formula!
 

THANKS, THAT WORKS!! D

"Gord Dibben" wrote:

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

=IF(A11,A1*B2,A1*B1)


Gord Dibben MS Excel MVP

On Tue, 1 Jan 2008 11:46:00 -0800, Danni2008
wrote:

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

need HELP with simple excel formula!
 

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(A11,B2,B1)

Rick


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