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     www.energyefficientbuild.com.   Jan-02-2014
question by Jenna VanderMost (http://productforums.google.com/forum/?zx=ftkkyxcf4zk8#!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!

https://docs.google.com/a/newfangledstudios.com/spreadsheet/ccc?key=0AvCYrWOI8coEdDBjbVRBU1lMR2s3bG9oTDBBV1JfT3c&usp=drive_web#gid=4
----------------------------------------------------------------------------------------------------
Since I could not Edit Jenna's spreadsheet, I have presented here an illustrative solution 


No comments:

Post a Comment