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

Attached Files

test.xlsx (16.7 KB, 10 views)