Results 1 to 3 of 3

Thread: When I enter a dot in the formula it displays the formula

  1. #1

    Unhappy When I enter a dot in the formula it displays the formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    When I enter the below formula it displays and works fine
    =IF(AND(AP1804>1,AJ1804=""),"1",IF(ISBLANK(AP1804),"",COUNTIF(AJ$139:AJ1804,AJ1804)))


    But as soon as I enter . in the first brackets, it just displays the whole formula, not the value

    =IF(AND(AP1804>1,AJ1804="."),"1",IF(ISBLANK(AP1804),"",COUNTIF(AJ$139:AJ1804,AJ1804)))

    Any ideas why could it be?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Obviously that shouldn't happen. Make sure that your cell format is not TEXT before entering the formula.


  3. #3
    Cool. Will check it. Thank you

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •