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