Caly
Board Regular
- Joined
- Jul 19, 2015
- Messages
- 159
- Office Version
- 365
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi I have a statement where I keep getting an error. How do I write this formula?
column A is for a unit of issue conversion where is may say 2.
columns B, D, and F will have prices for different products
Column H will have the product to use and column I will have the price based on the product in column I
For the column I formula I am trying to say if Column A is not blank and Column H either says one of the two product types that may be in Column B to multiply the price by the column A amount and if column A is blank then just use the price for the product.
here is an image of what I am trying
column A is for a unit of issue conversion where is may say 2.
columns B, D, and F will have prices for different products
Column H will have the product to use and column I will have the price based on the product in column I
For the column I formula I am trying to say if Column A is not blank and Column H either says one of the two product types that may be in Column B to multiply the price by the column A amount and if column A is blank then just use the price for the product.
here is an image of what I am trying