Results 1 to 5 of 5

Creating a function to simplify a more complex function

Threaded View

  1. #1
    Registered User
    Join Date
    05-28-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Creating a function to simplify a more complex function

    Greetings. I am a mid-level sort of Excel user, but I don't often create my own functions. I'm familiar with VBA for Access, but not for Excel.

    Anyway, I don't know if this is possible, but I have a formula that I'd like to make into its own function. I've tried looking up how to do this, but I can't find anything.

    The formula:
    =IF(AND(ISBLANK(A1751)=FALSE,ISBLANK(B1751)=FALSE)=TRUE,IF(ISBLANK(A1750)=TRUE,A1748,N1750),0)
    What I'm trying to do is make it so that rather than copying the cell again and again to where I need the formula, I can just create a new function, called FldPos, that will allow me to type "FldPos()" into a cell and have it behave as though this formula is in the cell (excelpt with relative cell references rather than specific ones

    Is that possible? If so, how can it be done?

    Thanks for any help anyone can give!
    Last edited by mk74; 05-28-2011 at 09:20 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1