Forum Discussion
Tiffanee_Higgins
Jul 28, 2023Copper Contributor
Excel formula
Need to write formula for if an item is sold the number of items will be placed in a cell and then the total number of items will be multiplied by the cost and placed in a cell labeled sold. If the no items were sold then the number entered in the cell would be zero or blank and a check mark or zero would be placed in a cell labeled not sold
so…. If D50 is zero or blank then 0 in I50
or if D50>0 D50*E50 placed in H50
- Riny_van_EekelenPlatinum Contributor