SUMIF type function for product?

  • Thread starter Thread starter donafuin
  • Start date Start date
D

donafuin

Okay here's the deal...the spreadsheet I'm working on is for an NY based
company where sales tax is only charged to NY residents. Therefore,
only if the cell in the state column says "NY" do we need to multiply
the cell in the price column by .0825. Right now the formula D2*.0825
is in there and we input 0 if it is not a NY customer, however this
seems inefficient to me.

Is there a way to use the SUMIF function, or any other function, to
create a formula that would multiply the cell in the price column by
..0825 ONLY IF the cell in the state column says "NY."

I would really appreciate any suggestions. Thanks!
 
Back
Top