Results 1 to 3 of 3

cell display does not change

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    London
    MS-Off Ver
    Excel 2016 (Mac)
    Posts
    69

    cell display does not change

    Hello everyone

    I have a formula which equates integers to quartertone-pitches.
    My problem: if the cell designed for number-input is empty, the cell with the pitch-name displays B≠ (b-quarter-sharp).
    Please see the attached file: rows 1 and 2 are normal; row 9 demonstrates the problem.

    I would need the cell to be empty (or display "0" or "value") if there is no number inputted.
    How can I change that without altering the rest of the formula?

    Thank you in advance for your advice.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1