Forum Discussion

Tiffanee_Higgins's avatar
Tiffanee_Higgins
Copper Contributor
Jul 28, 2023

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

Resources