View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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