Results 1 to 7 of 7

Thread: Excel - Change cell formula from nested IFs to ??

Threaded View

  1. Apr 21st, 2005, 08:30 PM #1
    crptcblade
    crptcblade is offline

    Thread Starter
    The Devil crptcblade's Avatar
    Join Date
    Aug 2000
    Location
    Quetzalshacatenango
    Posts
    9,091

    Resolved Excel - Change cell formula from nested IFs to ??

    So I have this ugly formula on a bunch of rows that looks like...
    Code:
    = (H23*IF(D23="YT",0.39,IF(D23="M/C",0.4,IF(D23="KK",0.45,IF(D23="M",0.71,0)))))
    and I want to use VBA and change it over to a Select Case type of thing. I've never really worked with VBA before. What event(s) would I used, and so forth? Who wants to help me out? I'll send you five teeth for your trouble.

    Last edited by crptcblade; Apr 22nd, 2005 at 07:24 AM.
    Laugh, and the world laughs with you. Cry, and you just water down your vodka.


    Take credit, not responsibility
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width