Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Simple questions (2002)

    These are probably very simple questions, but I appear to be Excel phobic today.

    I have an "IF" formula that checks a cell for greater than zero (display "Cut") or less than zero (display "Fill"). But if the formula value is zero or has no values to calculate, the display is "Cut". How do I change the formula to display a blank cell?

    Cell F10 has the formula =D10-E10
    Cell G10 has the formula =IF(F10>0,"Cut",IF(F10<0,"Fill"," "))


    Another question:

    I want to copy the values displayed in the cells to paste elsewhere. The actual value in the cell could have many decimal places, but the display is for only one decimal place. I want the results to have only one decimal place as the actual value in the cell.

    I know these questions have been asked before, but I can't seem to find the answers.

    Thank you all.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Simple questions (2002)

    The formula in G10 will do what you describe, the problem is due to rounding. If the value in F10 is displayed to 1 decimal place it may display as 0.0 but the actual value could be something different so the formula in G10 will not show the a blank.

    Do you want the value in F10 to be rounded to 1 decimal place?, if so use the following formula:
    <code>=ROUND(D10-E10,1)</code>
    Your formula in G10 will now work as expected.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Simple questions (2002)

    Concerning the first question the problem is that when data has not been entered in any cells (like on the template) the value in cell G10 is "Cut". How do I get it to be blank?

    The other question is for a different workbook.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Simple questions (2002)

    Sorry, Tony. I think the lightbulb has finally turned on.

    I said I was brain dead today.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •