Results 1 to 2 of 2

Thread: Need Excel Help

  1. #1
    Isa4u is offline Senior Member+
    Last Online
    29th October 2022 @ 07:56 PM
    Join Date
    12 Nov 2009
    Location
    Lahore
    Age
    37
    Gender
    Male
    Posts
    162
    Threads
    17
    Credits
    1,312
    Thanked
    6

    Default Need Excel Help

    Adaab all Frnds & Experts:

    i make a function in excel vba which calculate squar of a number its works fine,

    "
    Function mynum(number)
    'returns square of number'
    mynum = number ^ 2
    End Function
    "
    when i write function in this way =mynum(f3&f4), where f3=4 and f4=6 it return me ans 2116
    i want to know how it be calculated
    here are some other values which ans as follow
    4&5=2025
    5&5=3025
    4&10= 168100
    how calculations are done help plz
    wait for your reply

  2. #2
    sayhellotoit's Avatar
    sayhellotoit is offline Senior Member
    Last Online
    23rd September 2017 @ 07:51 PM
    Join Date
    01 May 2009
    Posts
    1,003
    Threads
    5
    Credits
    53
    Thanked
    127

    Default

    Write it as:
    =mynum(f3)
    f3=3, it will display 9

    =mynum(f4)
    f4=4, it will display 16

    What is the reason of putting & in f3 and f4 ?

Similar Threads

  1. Answered MS Word Ki file ko JPG me kesy convert kru?
    By 1heart2pain in forum Ask an Expert
    Replies: 10
    Last Post: 24th May 2010, 02:34 AM
  2. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

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
  •