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