1. Missed the live Ask the Expert event?
    Not to worry. Check out the archived thread of the Q&A with Ken Hutcheson, President of U.S. Lawns, and the LawnSite community in the Franchising forum .

    Dismiss Notice

Excel Question

Discussion in 'Business Operations' started by ksland, Feb 20, 2005.

  1. ksland

    ksland LawnSite Senior Member
    Posts: 927

    Is there a way to enter a value in a cell that has a formula attached to it WITHOUT it being part of the calculation. Say Cell A3 has the formula A1*A2 and I want to enter text into A2 and have it treat it like a zero or not recognize it all together.
  2. Critical Care

    Critical Care LawnSite Bronze Member
    Posts: 1,654

    Look at the attached file. From A3-A8 is a combination of numeric and text values. By using the IF function you can create another column where all text values give you a 0 value. Now you can add, multiply, or do whatever you want to with this new column. - Bruce

    Attached Files:

Share This Page