+ Reply to Thread
Results 1 to 1 of 1

Count or if statement re dollar value in cell??

  1. #1
    Registered User
    Join Date
    08-13-2007
    Posts
    31

    Talking Count or if statement re dollar value in cell??

    Hi all. thought I'd up a workbook
    I'm trying to see if any cell in a column L6:L40 on sheet back! and sheet backa! contains any monetary value ($200 example in 5 cells maybe or just one cell) and If it does I want the words "you need to bank today" in another cell somewhere on the sheet appear if the cells are empty nothing to appear.

    I hope that I have explained it clearly

    Thanks for any and all help
    StephenW

    SOLVED here is the answer if anyone else may need it..........

    Place this formula in e42
    =COUNTIF(L5:L40,">=0")+COUNTIF(Back1a!L5:L40,">=0")

    and this one in e43
    =IF(E42>0,"How much did you bank today?","")

    If any cell contains a number L5:L40 it will count how many times the cells are not empty but that does'nt matter as long as if one is full it will display the words " How much did you bank today "

    thanks for looking
    Attached Files Attached Files
    Last edited by stephenw; 10-02-2007 at 03:23 AM.

+ Reply to Thread

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