Pulling product pricing from worksheet into proposal template
I'm trying to build a proposal template that will pull prices from the
product spreadsheet (sheet 1). The formula I need is when the price for a
component is less than zero it would use the word "Included" in the proposal
template. The prices are in sheet 1. The proposal template would be located
in sheet 2.
|