Thread: difficulty with logical - if - and
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_3_] Alan Beban[_3_] is offline
external usenet poster
  
Posts: 130
Default difficulty with logical - if - and
Assuming that B2 below was a typo,

=IF(AND(B11,B3.0001),B1*B3,"")

Alan Beban

billabong wrote:
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

Reply With QuoteReply With Quote