Results 1 to 4 of 4

Macro/function for this formula

Threaded View

Wskip49 Macro/function for this... 07-11-2008, 02:49 PM
Richard Buttrey That's some hell of a... 07-11-2008, 03:01 PM
mudraker range("a1").formula ... 07-11-2008, 06:41 PM
shg Based on the somewhat regular... 07-11-2008, 07:17 PM
  1. 07-11-2008, 02:49 PM #1
    Wskip49 is offline
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    399

    Macro/function for this formula

    Can this be put into a macro/function?

    =IF(OR(A18=P!$B$9,A18=P!$B$10,A18=P!$B$11,A18=P!$B$12,A18=P!$B$13,A18=P!$B$14,A18=P!$B$15,A18=P!$B$16),P!$A$21,IF(OR(A18=P!$B$17,A18=P!$B$18,A18=P!$B$19,A18=P!$E$29),P!$A$22,IF(OR(A18=P!$E$31,A18=P!$E$32,A18=P!$E$33,A18=P!$E$34),P!$A$32,IF(OR(A18=P!$E$14,A18=P!$E$15,A18=P!$E$16,A18=P!$E$17,A18=P!$E$18,A18=P!$E$19,A18=P!$E$20,A18=P!$E$21,A18=P!$E$22),P!$A$26,IF(OR(A18=P!$E$9,A18=P!$E$10,A18=P!$E$11),P!$A$20,IF(OR(A18=P!$E$23,A18=P!$E$24,A18=P!$E$25,A18=P!$E$26,A18=P!$E$27,A18=P!$E$28),P!$A$27,IF(A18=P!$E$13,P!$A$28,Payroll!$G$2)))))))
    Last edited by Richard Buttrey; 07-11-2008 at 02:55 PM. Reason: Code tags more appropriate than Quote Tags
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1