Results 1 to 4 of 4

IF Formula Inquiry

Threaded View

  1. 10-21-2010, 12:19 PM #1
    Mrgbolee
    Mrgbolee is offline
    Registered User
    Join Date
    10-21-2010
    Location
    NC
    MS-Off Ver
    Excel 2003
    Posts
    2

    IF Formula Inquiry

    Hello am working on the formula below,
    =IF(COUNTA(F2)>0,"HSD",IF(COUNTA(F2)=0,"",IF(COUNTA(F2)=Standard Rate,"","HSD")))

    What I need to do is ( if there is nothing in F2 populate nothing, if there is the word "Standard Rate" in F2 populate nothing, if there is something in F2 that is not the word "Standard Rate" populate HSD).

    Does any one know how to write this formula?? Please Help??
    Last edited by Mrgbolee; 10-21-2010 at 12:48 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1