Multiple IF formulas that are not nested still returning #VALUE!
I am working on an order form that needs to remain as simple as it currently is. The If statements test to see if a cell is greater than 0. (quantity or how many) If it is then it multiplies that cell by the cell next to it which is the price. Then I add up the cells.
As long as there is a value in the cells I get a proper outcome. If a cell is empty the cell returns #VALUE!.
I looked at putting the logic within each cell but that would require another column and add more complexity to this order form. The people I work with need simple.
Thanks, David
|