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 on 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