View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
billabong billabong is offline
external usenet poster
 
Posts: 14
Default difficulty with logical - if - and

I'm encountering difficulty with the following in VBA:

Quantity = cell B1
Price = cell B3
Gross amount = cell B5

How can I write the following logical if statement as follows:

If B1 is greater than 1, and B2 is greater than .0001, then (multiply
both together in B5, or else leave blank.

Thank you in advance.
Manuel