Results 1 to 15 of 15

Formula Issue With Blank Cells

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    906

    Formula Issue With Blank Cells

    Hello Again,

    I have a small issue with formula. I an calculating % for Increasing & Decreasing amount. Not the problem is if i leave the cell blank formula is not working. I have to enter cell value as 1 (One) in range F3:J10.

    Want i want here is i want to leave the cells blank instead of returning the value as 1. Can any one help me please.

    Sample file is attached.
    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