Results 1 to 6 of 6

fix formula for a 0 if blank space

Threaded View

  1. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: fix formula for a 0 if blank space

    Perhaps..this is what you want

    IF(I3="",0,your_formula)
    Last edited by Ace_XL; 08-28-2012 at 02:47 AM.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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