245 Views 2 Replies Latest reply: Feb 2, 2013 5:08 PM by Apple Sauce11
Currently Being ModeratedFeb 2, 2013 8:49 AM (in response to Apple Sauce11)
I am a salesman, and i give quotes over the phone or at the door for cable, internet and telephone services. I would like to be able to give people quotes for the total cost of the package and added extras. Please look at graphic below
Looks like the graphic I uploaded is not displaying after i post message, so I will explain further.
I would like to total the row going accross for each row I create. for example if I have a field called "upgrade premium". and enter "yes" int the cell below, I would like that value to add $5.00 to the total. also next to it, say I have a field called "add hd box" and I enter a 1 there, i would like the value to be $5.00, however if I enter 2, $10.00, if i enter 3, $15.00 and so on and so forth.
Also for every row created in that same table, I would like the same forumulas to be automatically created. Is it possible to do what I am looking for and how difficult would it be to accomplish it? If so can anyone steer me in the right direction?
Thank you much...