Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty with Sum+IF Function | Excel Worksheet Functions | |||
Help!!! - logical function for someone not very logical | Excel Worksheet Functions | |||
Function Difficulty | Excel Discussion (Misc queries) | |||
Formula difficulty | Excel Discussion (Misc queries) | |||
Difficulty with code | Excel Programming |