Results 1 to 4 of 4

adding empty cell only if nothing else is entered in referring cells

Threaded View

  1. #1
    Registered User
    Join Date
    05-07-2010
    Location
    Narberth, Wales
    MS-Off Ver
    Excel 2003
    Posts
    9

    adding empty cell only if nothing else is entered in referring cells

    Hi

    I need to enter an empty "total" cell (text) in a "total" tab if the other cells are empty, otherwise enter a dash "==="

    refer to cell D29, D30 & D31 on the attached

    I know this formula is incorrect but hopefully it gives you the gist of what I'm trying to do

    =IF((Monday!I30)and(Tuesday!I30)and(Wednesday!I30)and(Thursday!I30)and(Friday!I30)="","","=====")

    many thanks in anticipation
    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