+ Reply to Thread
Results 1 to 2 of 2

About using IF formula

  1. #1
    Registered User
    Join Date
    04-10-2015
    Location
    Bangladesh
    MS-Off Ver
    Windows 2013
    Posts
    39

    About using IF formula

    Hi,

    I am trying to use a formula to count Yes or No but can't make it.
    Condition like -

    If cell A1 has any word then it will show Yes in cell B1, If cell A1 is blank then it will show "No".

    Example:
    A B
    June Yes
    No
    Japan Yes
    India Yes
    No
    India Yes.


    I can work with only. This can show only Yes but other cells remain "Blank" insted of "No"

    =If(A1="",A1,"Yes")

    I need help regarding this.

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: About using IF formula

    Looks like a double post

    http://www.excelforum.com/excel-form...f-formula.html
    Happy with my advice? Click on the * reputation button below

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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