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)
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= 0AvCYrWOI8coEdDBjbVRBU1lMR2s3b G9oTDBBV1JfT3c&usp=drive_web# gid=4
https://docs.google.com/a/
----------------------------------------------------------------------------------------------------
Since I could not Edit Jenna's spreadsheet, I have presented here an illustrative solution
No comments:
Post a Comment