Posts by Rai77

    Re: When I enter a letter, the function does not work


    Hey RoyUK - I'm not sure which Forum Rules you are refering to that you think I broke - and, I'm not sure what else I could have said in my thread title. I don't even know what a udf code is... I tried to explain the function I need as clearly as possible.


    You see, I'm new to Excel and it's language - I'm just getting started. That's why I'm here.


    The function I need is to be able to sum A1 and A2 - minus the 12 percent commision IF the sales line has a letter in it, and put that total in A3...does that help? But, I already have a funtion in A3 that keeps a "0" from appearing if there is not data in A1 and A2, and I posted that above. I'm trying not to have to deal with code or vba at this point - it's a little too advanced for me.

    .......................A .. ... B ......C......D........E......... F...... G..... H..... I
    1 - Expenses ..-10.....-15.... -15L...........-10K......-5.......................
    2 - Sales .........25T....50.......15L........................25C....................
    3 - Totals:........15......25.......35.....0.....-10........-20.....................

    Problem #1:


    When I enter a letter, the function does not work. When a Letter is entered in the Expenses Row (negative numbers only), it does not accept the letter - the letter simply disappears. When I enter a letter in the Sales Row (positive number), it throws off the sum function - the addition comes out incorrect. In the totals Row, A3, I have the following function: =IF(COUNTA(A1:A2),SUM(A1:A2), "")


    The reason I have this as the function, rather than a simple SUM function, is so that the Totals line does not show "0" until data is entered in the corresponding cells. But, I'm sure there are many other ways to obtain the same result.


    Basically, when I enter a Letter in the Sales Row, I need to multiply that sales amount time .12, or 12 percent - and then subtract the expenses and the commission from the sales number and have that appear in the Totals Row. But, not all columns will have letters and those numbers will just be added without commission fees showing.


    Data will be derived from this simple chart on different sheets to show; total sales, total sales by each person, total commission, total expenses, etc…
    Any suggestions? If you happen to have a formula, can you also explain Why the formula works - I'm trying to learn the language of Excel - Thank you!