Results 1 to 2 of 2

Thread: excel problems

  1. #1
    mcbtiger is offline Senior Member+
    Last Online
    5th May 2016 @ 03:51 AM
    Join Date
    15 May 2009
    Age
    43
    Posts
    59
    Threads
    53
    Credits
    990
    Thanked
    0

    Default excel problems



    yare mare problem ya hai kay mujhay excel ki file may say decimal values ka pata chalana hai is may kuch cell may round number hai for example

    100
    250
    523
    5.23
    1.0
    800
    900
    5.6

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    decemal values count karna hain ya pata karna ha k decimal hain ya whole.
    Agar Pata chalana ha tu tr this. I assume a1:a10 houses data

    In b1

    =IF(ISNUMBER(FIND(".",A1)),"Decimal","Whole")
    IN c1
    =countif(b1:b10,"decimal")

Similar Threads

  1. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  2. Solved MS Excel Some Problems
    By Syed Hamid Ali in forum Solved Problems (IT)
    Replies: 12
    Last Post: 5th May 2013, 09:48 PM
  3. Help Need about Excel Text Change Case Problems?
    By kashifundlas in forum Ask an Expert
    Replies: 5
    Last Post: 18th February 2013, 09:27 PM
  4. Not Working Zaara's Excel Tutorial In Pdf & 300 Excel Tips
    By iftikhar01 in forum General Discussion
    Replies: 94
    Last Post: 14th May 2012, 04:28 PM
  5. Solved Slam Excel problems solve kr dain plz
    By DJ_UMAR in forum Solved Problems (IT)
    Replies: 4
    Last Post: 18th April 2011, 06:52 PM

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
  •