Archive

Posts Tagged ‘form’

sales lead spreadsheet

March 30th, 2010 admin No comments

sales lead spreadsheet
Excel Question. How can you enter a relationship in a formula?

Trying to calculate the proportion of sales leads to a spreadsheet. So if someone has given 20 8 sales leads me, it would calculate 2.5: 1 ratio of closure. How to do that in Excel formulas? Any help is can be seen, and is 10 points better. :) Thanks!

You do not need, or want to waste space by concatenation. It's much better to make the division, then apply a custom number format. Configure your form and then go to Format – Cells. "Tongue Many choose the Custom category.'s Edition box: 0.0 ": 1" This will show that 2.5 2.5: 1 (just as written above, but you can add or remove spaces). With a custom number format, can still use the number of shapes and not lose an extra column just to see the result. Http: / / Tim www.tvmcalcs.com

Marketing ROI