I am trying to edit a formula in my excel spreadsheet. I am able to do this one line at a time bit would like to try and edit the whole sheet. I will post the formula below. What i need to change is that one of the multipliers changes from $1.95 to $2.00.
=IF(G7="Y",(IF(F7=0,0,(((F7*2)*1.95)+(H7*0.3166666)))),(IF(F7=0,0,((F7*1.95)+(H7*0.3166666)))))
Thanks,
Matt
Bookmarks