+ Reply to Thread
Results 1 to 4 of 4

IF Function

  1. 09-28-2009, 07:00 AM #1
    Loisw
    Loisw is offline
    Registered User
    Join Date
    05-29-2009
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2007
    Posts
    78

    IF Function

    HI,

    can anyone tell me why the IF function in cell G2 of the attached doc doesnt work?!

    Thanx
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-28-2009, 07:14 AM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: IF Function

    Not an ideal title but hard to know what to use in truth.

    =IF(LEFT(C2,1)="C",10%,IF(LEFT(C2,1)="S",12%,0))
    Last edited by DonkeyOte; 09-28-2009 at 07:29 AM. Reason: edited per R below...
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
  3. 09-28-2009, 07:27 AM #3
    romperstomper
    romperstomper is offline
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: IF Function

    DO,
    I think you meant:
    =IF(LEFT(C2,1)="C",10%,IF(LEFT(C2,1)="S",12%,0))
    without the asterisk.
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  4. 09-28-2009, 07:28 AM #4
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: IF Function

    Yes I did - thanks R - post edited.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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