J
John Sullivan
I have five colums: col 1) # of items on hand, col 2) #
of items remaining at end of day, col 3) number sold for
the day (col 1 minus col 2), col 4) price per item, col 5)
multiplication of # of items sold for the day times price
per item. Would like a formula that does not write a
value in column 5 (multiplication of # of items sold
times price per item) unless there is an entry in column
2.
of items remaining at end of day, col 3) number sold for
the day (col 1 minus col 2), col 4) price per item, col 5)
multiplication of # of items sold for the day times price
per item. Would like a formula that does not write a
value in column 5 (multiplication of # of items sold
times price per item) unless there is an entry in column
2.