Thursday, January 2, 2014

yogi_Set Up Spreadsheet For Line Item Charge For Activity Extended And Total Amount

                                          Google Spreadsheet   Post  #1468
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-02-2014
question by Jenna VanderMost (!category-topic/docs/spreadsheets/how-do-i/chrome-browser/Z8SVndLP3wQ)

from Jenna VanderMost ...

Thank you! Link is below. I am trying to create a spreadsheet to track hours with our rates. I have a column with a drop down list of different services, all services are $125/hour, with the exception of "Graphics" which is $175/hour. I basically want the formula to say, if column B is Editing, Producing, or Production, then multiply column D by 125. If column B is Graphics, then multiply column D by $175. Thanks!
Since I could not Edit Jenna's spreadsheet, I have presented here an illustrative solution